Re: [PHP-DB] IBM DB2 & PHP 4.3.2 behaviour

[Gerard Samuel]

Matt Schroebel wrote:

Gerard Samuel   wrote on Tuesday, August 19,
2003 2:32 PM:
understand on a fresh database startup, it takes time to get things
together to run. But sometimes it would seem like its going fast, then
othertimes, crawl
slower than snails.
   

I've found that, with an AS/400, I had to build the proper indexes, such
as an upper case only version for performing LIKE '%LASTNAME%' searches,
*and* tell DB2 which index to use on the SELECT statement such as:
SELECT MMLNAM from ADDRBOOKL2 where MMLNAM LIKE 'SAMUEL%'
If I didn't point the select to the index, for some reason it wouldn't
choose it.  The folks at IBM Rochester Support Line told me to do this,
but it seems to me that DB2 should be doing that leg work for me.  It
did decrease response time from 4 minutes to 5 seconds -- which is still
slow.
My biggest problem with it now, is that it seems it runs out of breath, 
every so often.
It would be fairly quick, then slow down, then pick up the pace, then 
slow down.
All this is run on a 1800XP/256M Ram Development box, where Im the only 
one accessing the database.
I would even go as far to say that MSSQL is faster than DB2, from what 
Ive seen so far...

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] IBM DB2 & PHP 4.3.2 behaviour

[Matt Schroebel]

Gerard Samuel   wrote on Tuesday, August 19,
2003 2:32 PM:

> I understand on a fresh database startup, it takes time to get things
> together to run. But sometimes it would seem like its going fast, then
> othertimes, crawl
> slower than snails.

I've found that, with an AS/400, I had to build the proper indexes, such
as an upper case only version for performing LIKE '%LASTNAME%' searches,
*and* tell DB2 which index to use on the SELECT statement such as:
SELECT MMLNAM from ADDRBOOKL2 where MMLNAM LIKE 'SAMUEL%'

If I didn't point the select to the index, for some reason it wouldn't
choose it.  The folks at IBM Rochester Support Line told me to do this,
but it seems to me that DB2 should be doing that leg work for me.  It
did decrease response time from 4 minutes to 5 seconds -- which is still
slow.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] IBM DB2 & PHP 4.3.2 behaviour

[Gerard Samuel]

For the most part, I got my code running with IBM DB2 8.1.3
But its slower than dirt.  Maybe 1 out of 10 times, a page would exceed 
the 30 second time limit.
I understand on a fresh database startup, it takes time to get things 
together to run.
But sometimes it would seem like its going fast, then othertimes, crawl 
slower than snails.
Im just checking with the crowd that uses DB2 via PHP to see if they get 
similar
behaviour with DB2.

Thanks.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php