Re: mysql cache query as xml

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



hi andrew i think you understand my problem a little,
but if 100 user load this query at the same time, the two mysql server had a lot to do! so i think to cache this query as xml to the application server local make thinks faster, but, i would like to have the same performance to read this xml document as read the query from mysql server...
i dont know why php is so slow to read the xml file...


Andrew Ballard schrieb:
On Fri, Jul 10, 2009 at 12:36 PM, Daniel Brown<danbrown@xxxxxxx> wrote:
   Chris;

   From my understanding of your question, your message (included
below in its entirety) is better sent to the MySQL General list, which
I've CC'd on this reply.  If you haven't yet, please subscribe there
at mysql-subscribe@xxxxxxxxxxxxxxx to follow the thread for responses.

   If I'm misunderstanding and you're asking a PHP-related question,
please rephrase your question.

I understood the question to be how to improve performance by caching
MySQL results into an XML document (which, given that it was posted
here) within a PHP script. Perhaps this is not the correct
interpretation, but if so it would be relevant.

However, I'm not sure I'd spend time trying to devise a "fast" XML
cache for a query that only took 0.3 seconds to execute. By itself,
that isn't bad performance unless this is a query that is called
frequently by several concurrent users. Personally, I'd look into ways
to improve the execution of the query itself in MySQL (making sure the
query is sargable and improving indexes, etc.) until I thought I had
exhausted everything there.

Just my 2 cents.

Andrew


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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux