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: [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
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

Re: [PHP] DB speed

2002-10-10 Thread Chris Hewitt
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

RE: [PHP] DB speed

2002-10-10 Thread tuxen
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,

RE: [PHP] DB speed

2002-10-10 Thread Simon Taylor
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-