If you are experiencing a delay when using SQL 2005 or SQL 2008 when accessing the Site Store Pro enabled store files, please change your connection string (Connections/SiteStoreProDB.asp) to use Driver={SQL Native Client}  instead of  Driver={SQL Server}. On certain installations, the "SQL Native Client" driver performs much more efficiently than the "SQL Server" driver.

For example, if your database connection file looks like:

MM_SiteStoreProDB_STRING  = "Driver={SQL Server};server=127.0.0.1;uid=sspro;pwd=test;database=store;"

Change it to....

MM_SiteStoreProDB_STRING  = "Driver={SQL Native Client};server=127.0.0.1;uid=sspro;pwd=test;database=store;"