MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: Optimizing a query to out-perform MS Access (easy, right?)
Posted by: Erin ONeill
Date: October 11, 2005 09:42AM

Hey Dave -
First off my bias is towards UNIX. I think MySQL runs better in the unix environment. I don't think of desktop OS's as particularily stable, nor fast. You forgot (or perhaps I couldn't find it??) the amount of RAM you have. It's difficult to make server setting suggestions without it. I highly recommend that you use at least 2GB in a production environment. I dream of 8 GB but 4 is as much as they'll give me (but for some reason they're really stingy with the hardware around here).

I see some server settings that could be tweaked but without knowing what the RAM is I dare not mention any numbers!

erin

Navigate: Previous Message• Next Message
Options: Reply• Quote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.