Hello to all, I'm new to mysql programming, I had recently switched from interbase6 to mysql to test speed differences.
I have builded a simple test loading (under win2k server) the mysql library (to achieve direct access). Into this bench I have run many times 100 sequential queries to test the bottlenecks. Similar as interbase, the process of open a tcp/port, build the objects for the query, close alls, obtain a waste of time into the the first connection phase: mysql_init mysql_options mysql_real_connect take the 90% of time remaining queries objects and closing procedures take only the 10% If you like take a look at www.dellapasqua.com/mysql_profile.gif I have builded a pooled dynamic db access for interbase to eliminate this wasting of time, now I like to do easy port to mysql, but I like to have these informations: I use mysql_options(MySQLP, MYSQL_OPT_CONNECT_TIMEOUT, @MyTime) where MyTime is the timeout of the connection; 1) how to set manual connection/disconnection? (I like to control the construction/destruction of the connection) 2) if isn't possible, what is the maximum value editable into @MyTime? So I can check for every query if the timeout is reached and build a new connection Now, interbase6 with my pooled access it's considerably faster with simply queries than MySql without pooling components (atleast 10 times faster for simply queries, where the connection time has a big impact). I hope to achieve the same kind of performance also with Mysql. Really thanks to everyone helping me. Best regards. Roberto Della Pasqua. --------------------------------------------------------------------- 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
