Re: [PHP] DB speed

2002-10-10 Thread Dan Ostrowski
Yes persistant connections to pg make a LOT of difference and are recommended.. I have never had overhead problems using them eaither. I am terribly sorry i didn't mention this before. Just make sure you have proper indexes and you should be good to go. regards, dan Uros Gruber wrote: >Hi!

RE: Re[2]: [PHP] DB speed

2002-10-10 Thread SHEETS,JASON (HP-Boise,ex1)
Sent: Thursday, October 10, 2002 2:29 PM To: tuxen Cc: [EMAIL PROTECTED] Subject: Re[2]: [PHP] DB speed Hi! I make some more test for this. When i enable pconect (persistant) the result amazed me. PGSQL Total time: 0.0070 Execution time: 0.0034 MySQL Total time: 0.0072 Execution time: 0.0027 Now P

Re[2]: [PHP] DB speed

2002-10-10 Thread Uros Gruber
- something tells me there >> are other factors contributing.. >> Cheers >> Simon >> >> -Original Message- >> From: Uros Gruber [mailto:[EMAIL PROTECTED]] >> Sent: 10 October 2002 14:17 >> To: [EMAIL PROTECTED] >> Subject: [PHP] DB speed >

Re: [PHP] DB speed

2002-10-10 Thread 1LT John W. Holmes
> >From my experience, I found this: > > Selecting 1000 records from 2 tables using a join, 10secs and up. I'd say you have a problem in your database / table configuration, i.e. indexes. There's no way a join between two tables that are properly indexed should take 10 seconds for only 1000 rows.

Re: [PHP] DB speed

2002-10-10 Thread PHP List
uxen > Cc: [EMAIL PROTECTED] > Subject: Re: [PHP] DB speed > > For SIMPLE SIMPLE selects and inserts, MySQL will probably remain > faster. If you are doing a very simple web set up where you are mostly > inserting and spitting out single table information, MySQL will be the >

RE: [PHP] DB speed

2002-10-10 Thread Randum Ian
: [PHP] DB speed For SIMPLE SIMPLE selects and inserts, MySQL will probably remain faster. If you are doing a very simple web set up where you are mostly inserting and spitting out single table information, MySQL will be the way to go. Anything else, I would recommend PostgreSQL. It's go

Re: [PHP] DB speed

2002-10-10 Thread Dan Ostrowski
t;got variable results from different db's - even got an odbc connection to >>access to run faster than mysql at one stage!! - something tells me there >>are other factors contributing.. >>Cheers >>Simon >> >>-Original Message- >>From: Uros Gruber

Re: [PHP] DB speed

2002-10-10 Thread Chris Hewitt
.. >-Original Message- >From: Uros Gruber [mailto:[EMAIL PROTECTED]] >Sent: 10 October 2002 14:17 >To: [EMAIL PROTECTED] >Subject: [PHP] DB speed > >And i wan't to know if this is normal. >PGSQL >Total time: 0.0576 >Execution time: 0.0185 > >MySQL &

RE: [PHP] DB speed

2002-10-10 Thread tuxen
ontributing.. > Cheers > Simon > > -Original Message- > From: Uros Gruber [mailto:[EMAIL PROTECTED]] > Sent: 10 October 2002 14:17 > To: [EMAIL PROTECTED] > Subject: [PHP] DB speed > > > Hi! > > I'm making some testing over DB.php (PEAR) >

RE: [PHP] DB speed

2002-10-10 Thread Simon Taylor
ssage- From: Uros Gruber [mailto:[EMAIL PROTECTED]] Sent: 10 October 2002 14:17 To: [EMAIL PROTECTED] Subject: [PHP] DB speed Hi! I'm making some testing over DB.php (PEAR) And i wan't to know if this is normal. I've made some script where I connect do SQL server and exec

[PHP] DB speed

2002-10-10 Thread Uros Gruber
Hi! I'm making some testing over DB.php (PEAR) And i wan't to know if this is normal. I've made some script where I connect do SQL server and execute one simple (1row) query. I use pgsql and mysql. tables and indexes are same for both servers. So test table is identical Whe i execute