We have a large application made using a special database/product (not an SQL database). This application also uses CGI (writen in C). CGI is used on every transaction to send a request to the product and format the result.
We want to write a log of EVERY transaction made by the customer in a MySQL database. Writing has to be very fast because customers are waiting for their results. We want to add code using "MySQL C API" to the already existing CGI. My question is about connecting to MySQL. If, for each transaction to write, the CGI : - starts a new connection - inserts the data; and - closes the connection Will it be slow ? Is there a way to share a pool of already open connections between all my customers ? Can I have permanent connections for each of my customers (150 - 250) ? This is a lot of connections! How can I know from an html page which connection I used before and continue using it ? Thank you. --------------------------------------------------------------------- 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