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:

   <id>some hash id</id>
   <title>category title </title>

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

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to