Use Postgres.
Computer Science Canada MySQL /etc/my.cnf tweaking |
| Author: | Martin [ Thu Apr 14, 2005 8:06 am ] |
| Post subject: | MySQL /etc/my.cnf tweaking |
Anyone around care to help me tweak my my.cnf file for MySQL? I think I've optimized my C code as much as I can, but I still think that this'd give me a bit of a boost. The database has a single connection from the client, takes a lot of data (about 2000 * 13 entries per minute) and no queries except for adding entries. If anyone cares to help, I can post more details. |
|
| Author: | wtd [ Thu Apr 14, 2005 1:43 pm ] |
| Post subject: | |
Use Postgres. |
|
| Author: | md [ Thu Apr 14, 2005 1:58 pm ] |
| Post subject: | |
or try sqlite... I don't know how much of a speed bost you'll get from tweaking your config file though |
|
| Author: | Martin [ Thu Apr 14, 2005 2:02 pm ] |
| Post subject: | |
Thanks for the help guys... 
Switching isn't an option at this point. |
|
| Author: | wtd [ Thu Apr 14, 2005 2:06 pm ] |
| Post subject: | |
Sorry. I'm not into micro-optimization. You could use a setup that does absolutely no checking of anything, but that's sacrificing safety for speed. (Which you've already done in using MySQL at all...) |
|
| Author: | rizzix [ Thu Apr 14, 2005 2:10 pm ] |
| Post subject: | |
yea i dont know if you can actually optimise the app that way.. wierd.. the only thing i can see a a possilble means of optimisation is load balancing.. and that too, its not the job of the programmer but the administrator. |
|