Neeraj, Monday, February 04, 2002, 7:55:15 AM, you wrote:
NA> Just a simple question. I am using perl DBI to connect to NA> mysql. Its like a daemon, so its always running. But NA> whenever i get a signal it connects to a database NA> (different database each time). So there are 2 ways NA> to do it NA> 1. I disconnect and connect each time NA> 2. I connect and keep the database handle and use 'use NA> $database' NA> each time to change database. NA> Can anybody throw some light as to which one is better and NA> are there any problems involved? The second way is right. But beware: the first way permits you to reboot mysql server without a need to shutdown your perl software. So I'd better run both methods - "use database" and "disconnect/connect" handlers on different signals. Anyway, thit advise is too general. NA> thanks -- For technical support contracts, goto https://order.mysql.com/ 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