VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-ASP Shopping Cart Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 VP-ASP 7.0 Questions
 slow product display in admin
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jayceew
VP-ASP New User

USA
111 Posts

Posted - April 18 2010 :  21:01:22  Show Profile  Reply with Quote
Hi All,
I've almost completed my site on my local host using IIS 7.5 and Microsoft SQL 2008. Everything works fine except for one thing. When I'm in the products display in admin and select a product it takes a minute or so to bring up the product I selected. Sometimes it will time out before the product comes up. I moved the db from my local host to my site host (VPASP) to see if there was a problem with my local server, but I got the same results. I did a SQL trace and I get a few hundred of this line:

RPC:Completed exec sp_cursorfetch 180150009,2,0,1 Internet Information Services

Anyone have this problem? Or can anyone suggest a fix?

Thanks
Jack

support
Administrator

4266 Posts

Posted - April 20 2010 :  04:04:25  Show Profile  Visit support's Homepage  Reply with Quote
Perhaps you could try the bug fix available in our page at :
http://helpnotes.vpasp.com/shopexd.asp?id=958

Then locate bug fix #50 Retriving records from database speed is slow.

You can follow the steps to fix the bug by scrolling down to bottom and update the files as mentioned in that part.

If it does not solve the issue, you can submit a ticket to our helpdesk at :
https://helpdesk.vpasp.com

We will try to look at your issue.

Hope this helps.

Wilson
VPASP Support
Go to Top of Page

jayceew
VP-ASP New User

USA
111 Posts

Posted - April 23 2010 :  22:12:06  Show Profile  Reply with Quote
Hi All,
Made it slightly faster but still slow. The site and searches are very fast. Only slow in view and edit products in the admin page.
I'll submit a ticket as soon as I can get the FTP working in IIS 7.5.
Thanks
Jack
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000