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!
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
- 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
>
> >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.
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
>
: [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
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
..
>-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
&
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)
>
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
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
11 matches
Mail list logo