Page 1 of 1

More than 117 000 requests to the database.

PostPosted: Tue Oct 28, 2014 11:15 pm
by Archibald
Hello!
I have bought RuposTel One Page (2.0.258.180914). After adding delivery methods (so far is about 120 units, but it will be more than 700) the component became to work very slowly.
Boot time is more than 30 seconds and there are more than 117 000 requests to the database. How can this be fixed?
Without your component downloading of pages is no more than 3 seconds.
Thanks for the help!

Re: More than 117 000 requests to the database.

PostPosted: Tue Oct 28, 2014 11:26 pm
by admin
Hello, pls enable opc's delayed shipping and DISABLE vm's opc + automatic shipment at vm config, checkout tab.

Your checkout will load faster than your vm's core checkout.

Opc in contrast with vm precalculates cart per shipping times payment method times. Vm only calculates it once, but requesting a POST.

We are about to create CSV shipping method which would use power of the database in ms vs hundreds of php classes and we can help you get this work very fast.

Best regards,stan

Re: More than 117 000 requests to the database.

PostPosted: Sat Nov 15, 2014 10:02 pm
by Archibald
Thanks for the reply, Stan!
I did as you said, but the boot time still takes more than 12 seconds. When will you make CSV shipping method? Without it I can not use the web-site.
Thank you!

Re: More than 117 000 requests to the database.

PostPosted: Mon Nov 17, 2014 6:00 pm
by admin
hello, you would not be able to use any sort of ecommerce for which you'd add thousands of "shipping methods". i suggest that you write me here what are your shipping restrictions per which the shipping should render, normally there are theses:
1. country, zip start, zip end, order amount start, order stop amount
2. sometimes a non-numerci logic is required (please specify)
3. sometimes state filter is needed as well.
4. special plugins like fedex require also city and address line to match their database

please specify if you'd like to run this under VM3 or VM2 and what are you basic seach quote dimensions.

best regards, stan