Hello Steeve, Tuesday, October 15, 2002, 9:57:04 PM, you wrote:
SG> We want to write a log of EVERY transaction made by the customer in a MySQL SG> database. Writing has to be very fast because customers are waiting for their SG> results. We want to add code using "MySQL C API" to the already existing CGI. SG> My question is about connecting to MySQL. SG> If, for each transaction to write, the CGI : SG> - starts a new connection SG> - inserts the data; and SG> - closes the connection SG> Will it be slow ? Is there a way to share a pool of already open connections SG> between all my customers ? SG> Can I have permanent connections for each of my customers (150 - 250) ? This is SG> a lot of connections! How can I know from an html page which connection I used SG> before and continue using it ? Opening a connection to MySQL is cheap. Opening a connection requires something like 1ms on a modern 700mhz processor. So you don't have to keep a pool of connections really. -- For technical support contracts, goto https://order.mysql.com/?ref=ma02-010c This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php