Extend Path Cache to use SQLite as caching mecahnism

j0rd - May 13, 2009 - 06:15
Project:Path Cache
Version:6.x-1.2
Component:Code
Category:feature request
Priority:normal
Assigned:Unassigned
Status:active
Issue tags:cache, dreamhost, patcache
Description

A lot of people would like to use this patch for Dreamhost slow remote database issues, but dreamhost does not support memcache.

It does on the otherhand support SQLite, which could be used as a local database cache.

Could this project be extended to SQLite to assist all us users on Dreamhost who could benefit from this.

Reason I bring this up, is because dreamhost support forwarded me to this link, when I complained my Drupal site was running too slow. Unfortunately my site is D6.x and doesn't support memcache.

http://dgtlmoon.com/speeding_up_drupal_5x_on_dreamhost_slow_no_more

#1

p4trizio - May 17, 2009 - 23:35

Hi,
Dreamhost suggested that to me too.
I tryed to install pathcache but I realized I cannot use it.
Any hints from the "drupalers dreamhosters"?

#2

j0rd - May 20, 2009 - 08:51

Dreamhost must know that we can not actually use that patch and provide us with that link to simply shut us up and have us spin our wheels for a couple days and then not ask again. Smart move on their part, but annoying none the less. The pathcache module could support dreamhost if we had SQLite as a caching mechanism, since I believe dreamhost support this.

Adding SQLite as caching should resolve this issue, since they do provide SQLite which would cache this table locally and reduce access times.

As for dreamhost, some of their servers are less loaded than others. I've been able to run drupal happily (although not speedy) with out issues on about 4-5 of their servers. It's just this one server which is causing me issues and dreamhost seems un-enthusiastic to move me off. I also have another reason, which I can not blame dreamhost for, which has lead to me find new hosting (linode.com) for this particular client and rethinking plans for future hosting with clients such as these.

I would still like this SQLite caching feature, as I will use it on my other clients dreamhost sites.

 
 

Drupal is a registered trademark of Dries Buytaert.