[wp-hackers] Use of ENGINE=MEMORY w/ dbDelta() possible?

[Mahmoud Al-Qudsi]

I put up a list on the download pages for the NST plugins, I'll copy it below:

* XCache for WordPress
http://neosmart.net/dl.php?id=12

* eAccelerator for WordPress
http://neosmart.net/dl.php?id=13

* File-Based Caching for WordPress
http://neosmart.net/dl.php?id=14 (already published to the list, will be up soon)

* APC for WordPress
http://txfx.net/files/wordpress/apc-object-cache.phps

* Memcached for WordPress
http://ryan.wordpress.com/2005/12/23/memcached-backend/


Am I missing any?


My code's a bit different from yours... I'm saving a lot of queries by using a normal INSERT query with an ON DUPLICATE trigger instead of issuing a DELETE then an INSERT for each and every call. I'm not splitting up serialized data though, just base64_encode() and storing it as a varbinary (which is limited by bytes not chars) in the database. Haven't gotten around to implementing the expirations, not sure if there's a point though seeing just how much slower database-caching is in 2.5 thanks to the increase in the number of hooks.

Here's my code, for what it's worth:
http://pastebin.ca/954824

-MQ

> -----Original Message-----
> From: wp-hackers-bounces at lists.automattic.com [mailto:wp-hackers-
> bounces at lists.automattic.com] On Behalf Of DD32
> Sent: Monday, March 24, 2008 5:18 AM
> To: wp-hackers at lists.automattic.com
> Subject: Re: [wp-hackers] Use of ENGINE=MEMORY w/ dbDelta() possible?
> 
> On Mon, 24 Mar 2008 14:10:08 +1100, Mahmoud Al-Qudsi
> <computerguru at neosmart.net> wrote:
> >> Theres a mysql memory object cache allready available, you may want
> to
> >> take a look at that:
> >> http://dd32.id.au/files/wordpress/object-cache-memcache.txt
> >> (Though it doesnt create the table for you)
> >
> > Bah, I wish I'd seen that before I wrote mine..
> 
> Theres been quite a few of them written, It might be an idea for
> someone to make a list of them for 2.5 releae.. Just because theres
> going to be people looking for a cacher..
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers