Re: IBM DB2 speed issues: why so slow?

Are you using connect, or pconnect? On the database machine, make sure you have the number of connections up. Also realize the DB2 can "pool" connections. This is a good thing, but until that pool's built up it can be a little slower than usual. DB2 has an absolutely HUGE number of configurables (mostly database side) and if you are using the DB2 Control Center, you can right-click on the database and get to it's properties there. Do note that not ALL of the configurables are not shown, and that the Control Center doesn't allow for full range on a couple of them. The DB2 command line is your friend, but it's a pain to get used to. Write some shell scripts... you can run "db2 <command>" from a DOS batch file or from a #!/bin/sh script. 'Luck! -Szii ----- Original Message ----- From: Tyson Lloyd Thwaites <tysonlt@webmedia.com.au> To: <php-db@lists.php.net> Sent: Tuesday, January 02, 2001 7:17 PM Subject: [PHP-DB] IBM DB2 speed issues: why so slow? > Hi, > > I am currently looking at IBM DB2 as a possible DB, but simple queries are > taking up to a second to run! It takes approx. 6 seconds to bring a page up that > connects to and queries a simple table, and about 1 second per query after that. > > Does anyone have any experience with DB2? Is there some vital tuning I have left > out? > > -- > > Regards, > > Tyson Lloyd Thwaites > I.T&e eCommerce Division > Adelaide > www.ite.com.au > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net