daemon?

Im doing a webpage with MySQL through the c API and i was wondering if it would be a good idea to write a daemon to avoid all the connecting/disconnecting every time the database is "queried". The daemon would simply be called through whatever cgi program i write to query the database. Anyone has any thought on that or better and simpler ideas? (note that im using c and not perl here)
Thanks!

Go to Freshmeat.net and see SQL Relay 0.8
http://freshmeat.net/news/2000/05/16/958463251.html

Thanks! Thats exactly what i was looking for an a bit more. It'll give me something to play with for a while i think

Or AFAIK you could write a wepapplication in php with phplib with a session and a user. Then you can start and stop a persistent mysql session on logon, and run whatever on the server as to your own security specifications.

Untried - never touched c, but a starting point would a search in the manual found under
http://www.php.net

and of phplib
http://phplib.netuse.de

Let me know of security issues if big ;-)

nicholas



[This message has been edited by nicholak (edited May 19, 2000).]