mysql cache query as xml

From: Date: Fri, 10 Jul 2009 16:22:02 +0000
Subject: mysql cache query as xml
Groups: php.general 
Request: Send a blank email to php-general+get-295148@lists.php.net to get a copy of this message
hi guys, i need some help by optimize the performance. my problem is that i need a lot of rows the whole site (don't ask i need the rows really :-) ) this is about ~4000 rows it will be loaded from mysql database in 0.3 seconds my idea was to cache this rows in a xml file like for example: <category> <id>some hash id</id> <title>category title </title> </category> ...... also load query from mysql first, save to xml using 6 hours, erase the cached file, load query against.... but to load the same num rows from xml during more then 3 seconds in comparison mysql need just 0.3 seconds. how can i optimize the reading from xml faster? server design: 2 mysql server (Master & Slave with Replication ) 8 Applikation Server with connect to the 2 mysql server this i the reason why i want to cache this query anyway! other querys just need about 0.0004 seconds, but this is the slowest query! i hope someone can help me or had a better ideas to solve this problem! thanks chris

« previous php.general (#295148) next »