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!
> >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
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 got FAR superior
featur
Simon Taylor wrote:
>Well obviously - cos MySQL rocks!!, but seriously I also did some tests and
>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..
>-Original M
I think i read something a while ago, about mysql being faster, having
less features, but postgres being a little slower but able to handle
LARGE databases better than mysql. I could be wrong, so dont take my
word for it. At the end of the day they are both good db's.
On Thu, 2002-10-10 at 09:02,
Well obviously - cos MySQL rocks!!, but seriously I also did some tests and
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-
8 matches
Mail list logo