Mysql 4 can cache queries. You can try using temporary tables, so you can break up joins.
Also, perhaps making a "rawdata" table placeholder. Put a timestamp field on your columns. Make the query and store somewhere the query itself, the results and the time they were last modified. Then when the next query comes, compare if one already exists on the database. If so, only grab the "rawdata", ie, the previous results. And read Mysql's manual section about optimization if you haven't done so already, since it has important tips. -- Julio Nobrega Pode acessar: http://www.inerciasensorial.com.br "Richard Baskett" <[EMAIL PROTECTED]> escreveu na mensagem [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Is there anyways to speed up MySQL queries? Or showing the results through > PHP? I have several queries that have about 8 left joins or so.. Yes very > huge and when you have lots of people using these functions at once it > really slows down.. Are there any practices that you can think of that would > speed up any sql queries? I was thinking of using stored procedures, but > after a bit of research I found ou= t that MySQL doesn=B9t have that yet so > that's a no go :( Or is there a way of storing common query results? I am > looking for _anything_ that will speed up showing results to large queries.. > > I do use the ob_gzhandler and that helps a bit... Help! :) > > Cheers and Thanks! > > Rick > > "Let us live as people who are prepared to die, and die as people who are > prepared to live." - James S. Stewart > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
