Gordon Bissell wrote:
> mySQL version: 3.22
> Platform : RedHat Linux 6
> I'm working on a C program that currently connects to a mySQL database,
> performs a simple query, and exits. This program will be called in response
> to user action from a web page (i.e it's likely it will be called often, and
> by many different users).
> I was wondering if a more efficient solution might be to have a C based
> program always running (and always connected to the mysql database). It
> could then accept requests from the web browser.
> Would this be worth my time (in other words is continually connecting and
> disconnecting from a mySQL database inefficient or doesn't it really
The developers have put alot of work into making connects as efficient
as possible, but given the choice on a high hit site - it's better for
your client program to be resident and use persistant connections.