I am currently implementing a database-ran webserver dll: Info: Ms Visual C++ MySQL ++ 1.7.1 MySQL-nt 3.23.47 MyISAM db. 3or 4 Queries in the application
Biggest Query: 66,000 records using LIKE "something%" Question: I am currently using a connection every time I query, but since this is a static dll, can I somehow keep a connection open for all the queries? I have tried just opening a connection before(one connection for the app, all threads use it), but sooner or later, the queries start causing exceptions and then returning no error until the dll faults because the connection closes. Is there a way to tell the database that the connection needs to handle multiple queries in a parrallel manner? Any other speed tweaks if I have to open a different connection for each query? Thanks in advance, Jeremy Beha --------------------------------------------------------------------- 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
