Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001011

Re: [PHP-DB] IBM DB2 speed issues: why so slow? From: szii <email protected>
Date: 01/03/01

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 <email protected>>
To: <php-db <email protected>>
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 <email protected>
> For additional commands, e-mail: php-db-help <email protected>
> To contact the list administrators, e-mail: php-list-admin <email protected> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>