| From: | Paul DuBois <paul(at)snake(dot)net> |
|---|---|
| To: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>, The Hermit Hacker <scrappy(at)hub(dot)org> |
| Cc: | randyboy <randyboy(at)whispers(dot)blackmist(dot)org>, Paul DuBois <paul(at)snake(dot)net>, Patrick Greenwell <patrick(at)stealthgeeks(dot)net>, Scott Perkins <2scott(at)bellsouth(dot)net>, mcgarry(at)tig(dot)com(dot)au, MySQL mailing list <mysql(at)lists(dot)mysql(dot)com>, postgresql-general <pgsql-general(at)postgreSQL(dot)org>, "php3(at)lists(dot)php(dot)net" <php3(at)lists(dot)php(dot)net> |
| Subject: | Re: [GENERAL] Re: [PHP3] Re: PostgreSQL vs Mysql comparison |
| Date: | 1999-10-04 14:09:49 |
| Message-ID: | v04220500b41e653610ae@[144.92.43.105] |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
At 10:30 PM -0400 10/3/99, Bruce Momjian wrote:
>>
>> What do/are the MySQL folks using for test data? maybe start off with
>> what they are using to time MySQL and then look at how PostgreSQL can do
>> it, maybe differently?
>>
>> Is there somewhere where the MySQL benchmarks can be downloaded from,
>> including teh data?
>>
>
>Let me address my recollection of that discussion. The basic issue is
>that MySQL is somewhat faster because they don't have any
>transactions/rollback capability, no user-defined types, and are SQL
>built on top of an ISAM-type file with the indexes inbedded in the file,
>so to add an index requires rebuilding the table.
>
>Second, the MySQL folks don't mention the features they _don't_ have,
>except now they mention they don't have transactions.
Uh ... what? Chapter 5 of the MySQL manual goes into the missing
functionality in some detail. I have never gotten the impression that
they're trying to hide what isn't present.
--
Paul DuBois, paul(at)snake(dot)net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 1999-10-04 15:11:00 | Re: [GENERAL] Re: [PHP3] Re: PostgreSQL vs Mysql comparison |
| Previous Message | amy cheng | 1999-10-04 14:07:23 | Re: [GENERAL] alpha and true64 port |