Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Improved caching system Rate Topic   - - - - -

 
  • zeke
  • Megamind
  • Administrators
  • Join Date: 01-Nov 05
  • 472 posts

Posted 19 April 2010 - 06:57 PM #1

Hello,

Just for an experiment I rewrote the cache storage using sqlite database to check the differences with file storage. Please try on your carts.

Just extract the file from zip archive and copy it to "core" directory, then clean up the "var/cache" directory.

See http://forum.cs-cart...ghlight=so slow for details

Attached Files



 
  • whiplash13
  • PM Extraordinaire
  • Members
  • Join Date: 01-Feb 08
  • 704 posts

Posted 19 April 2010 - 09:37 PM #2

Followed the steps you provided but I get the error below on all pages:

Fatal error: Class 'PDO' not found in /home/p2p/public_html/cart/core/class.registry.php on line 297
John
CS Cart 4.2.4

 
  • johnbol1
  • Never Re
  • Members
  • Join Date: 23-Feb 10
  • 4817 posts

Posted 19 April 2010 - 10:31 PM #3

worked on mine,
I cleaned up cache, then cache.db appeared in cache


John

Custom printed hi visibility clothing sale the UK's online hivis safety shop
v4.5.2


 
  • snorocket
  • Forum Janitor
  • Members
  • Join Date: 15-Mar 06
  • 2519 posts

Posted 20 April 2010 - 01:51 AM #4

Followed the steps you provided but I get the error below on all pages:

Fatal error: Class 'PDO' not found in /home/p2p/public_html/cart/core/class.registry.php on line 297

Same error here...
SNOROCKET.COM, Now Accepting PRE-ORDERS:
Customer Service (Helpdesk) Addon for CS-Cart v4.3.1
Quote and Invoicing Addon for CS-Cart v4.3.1

 
  • thanhh83
  • Member
  • Members
  • Join Date: 14-Aug 09
  • 40 posts

Posted 20 April 2010 - 02:14 AM #5

I thing we need to install PDO extension for server

http://www.php.net/m...nstallation.php

Is this correct zeke?
Buy Software Cheaper http://www.techlope.com

 
  • teksigns
  • Senior Member
  • Members
  • Join Date: 26-Jun 09
  • 181 posts

Posted 20 April 2010 - 03:57 AM #6

working great so far


thank you

 
  • brandonvd
  • is Super Awesome
  • Members
  • Join Date: 19-Dec 06
  • 2633 posts

Posted 20 April 2010 - 04:49 AM #7

Works fine for me.

I tried this with and without using Smartoptimizer. My site is definitely faster using this with Smartoptimizer versus just this mod.

Using Pingdom My speeds were:

4.7 seconds using this and Smartoptimizer

5.5 seconds using just Smartoptimizer

7.6 seconds using just this

Using the page speed thing for Firebug I scored 81/100 either way.

I don't know if any of this means anything to anyone, but there are the numbers anyway.

Brandon

 
  • thanhh83
  • Member
  • Members
  • Join Date: 14-Aug 09
  • 40 posts

Posted 20 April 2010 - 04:57 AM #8

order fast now

Thanks zeke
Buy Software Cheaper http://www.techlope.com

 
  • jobosales
  • Senior Member
  • Members
  • Join Date: 04-Nov 06
  • 3114 posts

Posted 20 April 2010 - 05:24 AM #9

brandon-

Were your times for initial page loads or for reloads after a page was cached?

Bob
CS-Cart 2.0.14 (testing)

 
  • brandonvd
  • is Super Awesome
  • Members
  • Join Date: 19-Dec 06
  • 2633 posts

Posted 20 April 2010 - 05:43 AM #10

I cleared the cache before I tested this. I actually have a cron job set up to clear my cache twice a day so my speeds are usually around this anyways.

Brandon

 
  • jobosales
  • Senior Member
  • Members
  • Join Date: 04-Nov 06
  • 3114 posts

Posted 20 April 2010 - 06:05 AM #11

I wonder if the improvements to the caching would reduce or eliminate the need to clear the cache, thus preserving the benefits of building the cache in the first place.

Bob
CS-Cart 2.0.14 (testing)

 
  • zeke
  • Megamind
  • Administrators
  • Join Date: 01-Nov 05
  • 472 posts

Posted 20 April 2010 - 07:32 AM #12

Followed the steps you provided but I get the error below on all pages:

Fatal error: Class 'PDO' not found in /home/p2p/public_html/cart/core/class.registry.php on line 297


I don't know why, but it seems like some php configurations are built with PDO support, but without native sqlite support. And vice-versa. If we decide to release this caching system, we'll add the access wrapper to work on both configurations.

 

Posted 20 April 2010 - 08:29 AM #13

Just uploaded this to mine version, everything seems to be working a lot faster, both on my localhost test server, and live server. :)

Definitely an improvement for me :)

 
  • Shr3k
  • Junior Member
  • Members
  • Join Date: 25-Mar 08
  • 12 posts

Posted 20 April 2010 - 10:55 AM #14

I'm glad to see my initial idea to store cache arrays in indexed DB turned to a acquisition. :D Hope we'll get memcached boost some day.

 
  • Raeandy
  • Member
  • Members
  • Join Date: 21-Aug 07
  • 54 posts

Posted 20 April 2010 - 11:53 AM #15

Followed the steps you provided but I get the error below on all pages:

Fatal error: Class 'PDO' not found in /home/p2p/public_html/cart/core/class.registry.php on line 297


Same error here. Is there any information about my host that I can provide you with Zeke to assist ?

 
  • whiplash13
  • PM Extraordinaire
  • Members
  • Join Date: 01-Feb 08
  • 704 posts

Posted 20 April 2010 - 02:57 PM #16

OK I installed PDO with sqlite3 and now it works. Seems faster but haven't run tests yet.
John
CS Cart 4.2.4

 
  • zeke
  • Megamind
  • Administrators
  • Join Date: 01-Nov 05
  • 472 posts

Posted 21 April 2010 - 08:37 AM #17

Same error here. Is there any information about my host that I can provide you with Zeke to assist ?


Send me phpinfo() output please.

 
  • Darius
  • Douchebag
  • Members
  • Join Date: 20-Apr 08
  • 3365 posts

Posted 21 April 2010 - 09:55 AM #18

Works very well, site seems to be loading much faster. Tested with 2.07

admin.php?dispatch=tools.phpinfo
Got PDO drivers - mysql, sqlite enabled.

 
  • The Tool
  • Been Here Way Too Long Member
  • Members
  • Join Date: 30-Mar 07
  • 3921 posts

Posted 22 April 2010 - 02:52 PM #19

I just had a look at zeke's file and I like the ideology behind it. It updates the cache files.

Has anyone that is testing this noticed that they don't have to clear cache as much or at all?

 
  • borescopeit
  • Banned for insults
  • Banned
  • Join Date: 18-Mar 10
  • 68 posts

Posted 23 April 2010 - 10:20 PM #20

I installed the hack, and it works flawlessly! Definitely the cart pages load way faster!
BORESCOPE IT INC. - Optical Devices for NDT Specialists
Running SC-CART 2.2.4 Pro. Trying to figure out how to run 10+
sub-stores and not pay $$$$$$ for Ultimate Licenses. ;)