<?xml version="1.0" encoding="utf-8" ?>
<?xml-stylesheet type="text/xsl" href="RSS_xslt_style.asp" version="1.0" ?>
<rss version="2.0" xmlns:WebWizForums="https://syndication.webwiz.net/rss_namespace/">
 <channel>
  <title>Web Wiz Support and Community Forums : Sql Versi&#111;n - MapPath not needed</title>
  <link>https://forums.webwiz.net/</link>
  <description><![CDATA[This is an XML content feed of; Web Wiz Support and Community Forums : Web Wiz Forums : Sql Versi&#111;n - MapPath not needed]]></description>
  <copyright>Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved.</copyright>
  <pubDate>Sat, 04 Apr 2026 06:43:01 +0000</pubDate>
  <lastBuildDate>Wed, 19 Nov 2003 02:51:04 +0000</lastBuildDate>
  <docs>http://blogs.law.harvard.edu/tech/rss</docs>
  <generator>Web Wiz Forums 12.08</generator>
  <ttl>360</ttl>
  <WebWizForums:feedURL>https://forums.webwiz.net/RSS_post_feed.asp?TID=7370</WebWizForums:feedURL>
  <image>
   <title><![CDATA[Web Wiz Support and Community Forums]]></title>
   <url>https://forums.webwiz.net/forum_images/web_wiz_forums.png</url>
   <link>https://forums.webwiz.net/</link>
  </image>
  <item>
   <title><![CDATA[Sql Versi&#111;n - MapPath not needed : Thanks I&amp;#039;ll look into it. ...]]></title>
   <link>https://forums.webwiz.net/sql-version-mappath-not-needed_topic7370_post36869.html#36869</link>
   <description>
    <![CDATA[<strong>Author:</strong> <a href="https://forums.webwiz.net/member_profile.asp?PF=1">WebWiz-Bruce</a><br /><strong>Subject:</strong> 7370<br /><strong>Posted:</strong> 19&nbsp;November&nbsp;2003 at 2:51am<br /><br />Thanks I'll look into it.]]>
   </description>
   <pubDate>Wed, 19 Nov 2003 02:51:04 +0000</pubDate>
   <guid isPermaLink="true">https://forums.webwiz.net/sql-version-mappath-not-needed_topic7370_post36869.html#36869</guid>
  </item> 
  <item>
   <title><![CDATA[Sql Versi&#111;n - MapPath not needed : Just for grins, I re-ran the base...]]></title>
   <link>https://forums.webwiz.net/sql-version-mappath-not-needed_topic7370_post36807.html#36807</link>
   <description>
    <![CDATA[<strong>Author:</strong> <a href="https://forums.webwiz.net/member_profile.asp?PF=1908">kmacy</a><br /><strong>Subject:</strong> 7370<br /><strong>Posted:</strong> 18&nbsp;November&nbsp;2003 at 1:15pm<br /><br /><P>Just for grins, I re-ran the base test of AspForum7.6 3 more times and came out to: (if you don't know what I am talking about read my earlier post)</P><P>64 requests per seconds (exact same as before)</P><P>Then I commented out the server.mappath call mentioned above and reran the test 3 times and got this:</P><P>68 requests per second.</P><P>May not seem like a lot but that simple little change is a 6% increase. Not bad for just making a simple little change.</P><P>&nbsp;</P>]]>
   </description>
   <pubDate>Tue, 18 Nov 2003 13:15:47 +0000</pubDate>
   <guid isPermaLink="true">https://forums.webwiz.net/sql-version-mappath-not-needed_topic7370_post36807.html#36807</guid>
  </item> 
  <item>
   <title><![CDATA[Sql Versi&#111;n - MapPath not needed : I was looking through the code...]]></title>
   <link>https://forums.webwiz.net/sql-version-mappath-not-needed_topic7370_post36799.html#36799</link>
   <description>
    <![CDATA[<strong>Author:</strong> <a href="https://forums.webwiz.net/member_profile.asp?PF=1908">kmacy</a><br /><strong>Subject:</strong> 7370<br /><strong>Posted:</strong> 18&nbsp;November&nbsp;2003 at 12:48pm<br /><br /><P>I was looking through the code and noticed if you are running the Sql Server version there are a couple of lines in the code that you can comment out (or wrap in an if then statement checking for Sql version).</P><P>I wouldn't even bring it up but the server.mappath is an expensive method because it has to read the file system each time it is called.&nbsp; </P><P>So, unless Borg says different, I'm going to comment out the following 2 lines in the common.asp file. (Only for SQL SERVER version!)</P><P>1) strDbPathAndName = Server.MapPath("admin/database/wwForum.mdb") 'This is the path of the database from this files location on the server </P><P>2)strCon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &amp; strDbPathAndName 'This one is for Access 2000/2002 .</P><P>Borg,<BR>Actually, you might just want to move:<BR>'Set the diffrent variables for diffrent database types<BR>If strDatabaseType = "SQLServer" Then %&gt;<BR><BR>up a few lines to right under :<BR>Set adoCon = Server.CreateObject("ADODB.Connection")</P><P>and then add a "Not" since you are already testing for SqlServer anyway.</P><span style="font-size:10px"><br /><br />Edited by kmacy</span>]]>
   </description>
   <pubDate>Tue, 18 Nov 2003 12:48:14 +0000</pubDate>
   <guid isPermaLink="true">https://forums.webwiz.net/sql-version-mappath-not-needed_topic7370_post36799.html#36799</guid>
  </item> 
 </channel>
</rss>