On Wed, February 25, 2009 8:43 am, Kirk Cerny wrote: > If the data is slow comming back where you are only doing SELECTs you > could look at compressing the data in mysql using myisampack. > http://dev.mysql.com/doc/refman/5.0/en/myisampack.html > > I have tried doing this on read only data with awesome success.
I don't think this fits his situation, because the data is being updated by other tools. It's just /this/ tool is only running selects. I'm curious as to why the selects should be causing a problem. How many queries per second are we talking about, and have you doublechecked that indexes are being used? -- Matthew Walker Kydance Hosting & Consulting, Inc. - http://www.kydance.net/ PHP, Perl, and Web Development - Linux Server Administration /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
