Programming C, C++, Java, PHP, Ruby, Turing, VB
Computer Science Canada 
Programming C, C++, Java, PHP, Ruby, Turing, VB  

Username:   Password: 
 RegisterRegister   
 MySQL /etc/my.cnf tweaking
Index -> General Programming
View previous topic Printable versionDownload TopicSubscribe to this topicPrivate MessagesRefresh page View next topic
Author Message
Martin




PostPosted: 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.
Sponsor
Sponsor
Sponsor
sponsor
wtd




PostPosted: Thu Apr 14, 2005 1:43 pm   Post subject: (No subject)

Use Postgres. Smile
md




PostPosted: Thu Apr 14, 2005 1:58 pm   Post subject: (No subject)

or try sqlite...
I don't know how much of a speed bost you'll get from tweaking your config file though
Martin




PostPosted: Thu Apr 14, 2005 2:02 pm   Post subject: (No subject)

Thanks for the help guys... Rolling Eyes

Switching isn't an option at this point.
wtd




PostPosted: Thu Apr 14, 2005 2:06 pm   Post subject: (No 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...)
rizzix




PostPosted: Thu Apr 14, 2005 2:10 pm   Post subject: (No 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.
Display posts from previous:   
   Index -> General Programming
View previous topic Tell A FriendPrintable versionDownload TopicSubscribe to this topicPrivate MessagesRefresh page View next topic

Page 1 of 1  [ 6 Posts ]
Jump to:   


Style:  
Search: