===============================================================
= Improve browsing speed on stores using a MS Access database =
===============================================================

As you may know, MS Access has a structural limit to 256 concurrent users. What this means is
that only 256 users can query the database at the same time. Unless your store experiences
extremely high traffic, the likelyhood of having 256 concurrent users is pretty slim.
However, there is another limitation that can affect performance. That is, MS Access only
supports 1 user updating the database at a time.

So if a user loads a page that updates the databse, the rest of the users on the site will
not be able to load a page that also updates the database and will experience a small delay
while the database is locked for the update.

Among other pages that update the database in ProductCart, there is viewPrd.asp, the product
details page, which is a very high traffic page. This page updates the database because it logs
the number of times a certain product is viewed.

You can improve performance by turning this feature off. To do so, follow these instructions:


viewPrd.asp -----------------------------

(1) Make a backup copy of pc/viewPrd.asp, then open the file for editing.

(2) Locate the code:

 
' --> increase visits for product <--
mySQL="UPDATE products SET visits=visits+1 WHERE idProduct="& pIdProduct
 
set rs=conntemp.execute(mySQL)
 
if err.number <> 0 then
 call closeDb()
  response.redirect "techErr.asp?error="& Server.Urlencode("Error in viewPrd: "&err.description) 
end if

(3) Remove or comment out the above code.
 

configurePrd.asp (BTO users only) --------
 
(1) Make a backup copy of pc/configurePrd.asp, then open the file for editing.

(2) Locate the code
 
' increase visits
mySQL="UPDATE products SET visits=visits+1 WHERE idProduct="& pIdProduct
 
set rs=conntemp.execute(mySQL)
 
if err.number <> 0 then
  response.redirect "techErr.asp?error="& Server.Urlencode("Error in viewPrd: "&err.description) 
end if

 
(3) Remove or comment out the above code.

===============================================================
===============================================================