RE: MySQL vs. Postgres

2000-09-02 Thread Scott Thompson
you can find the perl software i use (free) at www.awsd.com :-) -Original Message- From: Sanjeev Gupta [mailto:[EMAIL PROTECTED] Sent: Friday, September 01, 2000 1:05 AM To: Scott Thompson Cc: debian-isp@lists.debian.org Subject: RE: MySQL vs. Postgres >On Wed, 30 Aug 2000, Sc

RE: MySQL vs. Postgres

2000-09-02 Thread Scott Thompson
you can find the perl software i use (free) at www.awsd.com :-) -Original Message- From: Sanjeev Gupta [mailto:[EMAIL PROTECTED]] Sent: Friday, September 01, 2000 1:05 AM To: Scott Thompson Cc: [EMAIL PROTECTED] Subject: RE: MySQL vs. Postgres >On Wed, 30 Aug 2000, Scott Thomp

RE: MySQL vs. Postgres

2000-09-01 Thread Sanjeev Gupta
On Wed, 30 Aug 2000, Scott Thompson wrote: > Some stats for you. Keep in mind that these are only for the webserver. > > Hits Bytes Visits PViews Month >8,891,404 58,798,965,869 211,007 1,528,073 Jun 2000 > 10,853,047 57,775,413,897

RE: MySQL vs. Postgres

2000-09-01 Thread Sanjeev Gupta
>On Wed, 30 Aug 2000, Scott Thompson wrote: > > > Some stats for you. Keep in mind that these are only for the webserver. > > > > Hits Bytes Visits PViews Month > >8,891,404 58,798,965,869 211,007 1,528,073 Jun 2000 > > 10,853,047 57,77

RE: MySQL vs. Postgres

2000-08-31 Thread Scott Thompson
Yes it was compiled into the Apache server, as well as we were using the C api for mysql. On Wed, 30 Aug 2000, Scott Thompson wrote: > > > Some stats for you. Keep in mind that these are only for the webserver. > > Hits Bytes Visits PViews Month >8,891,4

RE: MySQL vs. Postgres

2000-08-31 Thread Scott Thompson
Yes it was compiled into the Apache server, as well as we were using the C api for mysql. On Wed, 30 Aug 2000, Scott Thompson wrote: > > > Some stats for you. Keep in mind that these are only for the webserver. > > Hits Bytes Visits PViews Month >8,891,

RE: MySQL vs. Postgres

2000-08-31 Thread Marco Colombo
On Wed, 30 Aug 2000, Scott Thompson wrote: > > > Some stats for you. Keep in mind that these are only for the webserver. > > Hits Bytes Visits PViews Month >8,891,404 58,798,965,869 211,007 1,528,073 Jun 2000 > 10,853,047 57,775,413,8

RE: MySQL vs. Postgres

2000-08-31 Thread Marco Colombo
On Wed, 30 Aug 2000, Scott Thompson wrote: > > > Some stats for you. Keep in mind that these are only for the webserver. > > Hits Bytes Visits PViews Month >8,891,404 58,798,965,869 211,007 1,528,073 Jun 2000 > 10,853,047 57,775,413,

Re: MySQL vs. Postgres

2000-08-31 Thread Dariush Pietrzak
> Which file based database system is faster than mysql? I tried Berkeley > db3 (although with transaction code) and it was horrible slow! old one is fast. hmm i thought the new one was db2, uh, some glitch in my memory files. I've seen benchmarks comparing various db-databases (gdbm, ndbm etc) a

Re: MySQL vs. Postgres

2000-08-31 Thread Dariush Pietrzak
> Which file based database system is faster than mysql? I tried Berkeley > db3 (although with transaction code) and it was horrible slow! old one is fast. hmm i thought the new one was db2, uh, some glitch in my memory files. I've seen benchmarks comparing various db-databases (gdbm, ndbm etc)

Re: MySQL vs. Postgres

2000-08-30 Thread R. W. Rodolico
> > > postgres is using record-level locking, what does mysql do, is it > > locking the whole table ? what are rollbacks? what other advantages are > AFAIK mysql locks whole table, > rollback is term used with transaction - thing is, you put some sql > statements inside transaction, and one of

RE: MySQL vs. Postgres

2000-08-30 Thread Scott Thompson
Some stats for you. Keep in mind that these are only for the webserver. Hits Bytes Visits PViews Month 8,891,404 58,798,965,869 211,007 1,528,073 Jun 2000 10,853,047 57,775,413,897 224,862 1,375,197 Jul 2000 9,121,259 53

Re: MySQL vs. Postgres

2000-08-30 Thread Robert Davies
My workplace used php3 + mysql, then php3 + oracle, now looking at a combination of php3 + local mysql + master oracle db (the local mysql db's would act as caches for fast answers to most page queries). This is for scalability and availability reasons. php most commonly used with mysql, told by

Re: MySQL vs. Postgres

2000-08-30 Thread Christian Hammers
On Wed, 30.08.00 18:02 +0200, Dariush Pietrzak wrote: > Hmm, if you need fast why use sql server? you could use databases > in files. they're fast, simple etc. Which file based database system is faster than mysql? I tried Berkeley db3 (although with transaction code) and it was horrible slow! bye

Re: MySQL vs. Postgres

2000-08-30 Thread R. W. Rodolico
> > > postgres is using record-level locking, what does mysql do, is it > > locking the whole table ? what are rollbacks? what other advantages are > AFAIK mysql locks whole table, > rollback is term used with transaction - thing is, you put some sql > statements inside transaction, and one of

Re: MySQL vs. Postgres

2000-08-30 Thread Dariush Pietrzak
> postgres is using record-level locking, what does mysql do, is it > locking the whole table ? what are rollbacks? what other advantages are AFAIK mysql locks whole table, rollback is term used with transaction - thing is, you put some sql statements inside transaction, and one of them fail, you

Re: MySQL vs. Postgres

2000-08-30 Thread hendriks
hi, Sorry, not that familiar with sql servers. postgres is using record-level locking, what does mysql do, is it locking the whole table ? what are rollbacks? what other advantages are there in using postgres instead of mysql ? i maintain a small hosting server, that runs mysql (beside apache,

RE: MySQL vs. Postgres

2000-08-30 Thread Scott Thompson
Some stats for you. Keep in mind that these are only for the webserver. Hits Bytes Visits PViews Month 8,891,404 58,798,965,869 211,007 1,528,073 Jun 2000 10,853,047 57,775,413,897 224,862 1,375,197 Jul 2000 9,121,259 5

Re: MySQL vs. Postgres

2000-08-30 Thread Robert Davies
My workplace used php3 + mysql, then php3 + oracle, now looking at a combination of php3 + local mysql + master oracle db (the local mysql db's would act as caches for fast answers to most page queries). This is for scalability and availability reasons. php most commonly used with mysql, told b

Re: MySQL vs. Postgres

2000-08-30 Thread Christian Hammers
On Wed, 30.08.00 18:02 +0200, Dariush Pietrzak wrote: > Hmm, if you need fast why use sql server? you could use databases > in files. they're fast, simple etc. Which file based database system is faster than mysql? I tried Berkeley db3 (although with transaction code) and it was horrible slow! by

Re: MySQL vs. Postgres

2000-08-30 Thread Dariush Pietrzak
> postgres is using record-level locking, what does mysql do, is it > locking the whole table ? what are rollbacks? what other advantages are AFAIK mysql locks whole table, rollback is term used with transaction - thing is, you put some sql statements inside transaction, and one of them fail, yo

Re: MySQL vs. Postgres

2000-08-30 Thread hendriks
hi, Sorry, not that familiar with sql servers. postgres is using record-level locking, what does mysql do, is it locking the whole table ? what are rollbacks? what other advantages are there in using postgres instead of mysql ? i maintain a small hosting server, that runs mysql (beside apache

RE: MySQL vs. Postgres

2000-08-30 Thread Scott Thompson
r Admin Internet Brokers Group [EMAIL PROTECTED] http://www.internetbrokers.ab.ca Office: (403) 232-1032 Fax: (403) 265-2843 -Original Message- From: Arno Vije [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 30, 2000 9:35 AM To: debian-isp@lists.debian.org Subject: MySQL vs. Postgres Hi

Re: MySQL vs. Postgres

2000-08-30 Thread Dariush Pietrzak
> If you don't need record-level locking, rollbacks, etc. then I would > recommend MySQL, simply because it's very fast. Hmm, if you need fast why use sql server? you could use databases in files. they're fast, simple etc. If you need to create apps based on SQL you will need transactions, and rec

Re: MySQL vs. Postgres

2000-08-30 Thread Art Sackett
On Wed, Aug 30, 2000 at 06:34:54PM +0200, Arno Vije wrote: > where setting up some servers for a small ISP, > they want to have a SQL database, but i`m in > doubt. Which one would you recommend, mysql or postgres? > The SQL database will be used in combination with PHP3 (or 4) > to generate dyn

MySQL vs. Postgres

2000-08-30 Thread Arno Vije
Hi, where setting up some servers for a small ISP, they want to have a SQL database, but i`m in doubt. Which one would you recommend, mysql or postgres? The SQL database will be used in combination with PHP3 (or 4) to generate dynamic websites. greets, :::

RE: MySQL vs. Postgres

2000-08-30 Thread Scott Thompson
r Admin Internet Brokers Group [EMAIL PROTECTED] http://www.internetbrokers.ab.ca Office: (403) 232-1032 Fax: (403) 265-2843 -Original Message- From: Arno Vije [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 30, 2000 9:35 AM To: [EMAIL PROTECTED] Subject: MySQL vs. Postgres Hi, where

Re: MySQL vs. Postgres

2000-08-30 Thread Dariush Pietrzak
> If you don't need record-level locking, rollbacks, etc. then I would > recommend MySQL, simply because it's very fast. Hmm, if you need fast why use sql server? you could use databases in files. they're fast, simple etc. If you need to create apps based on SQL you will need transactions, and re

Re: MySQL vs. Postgres

2000-08-30 Thread Art Sackett
On Wed, Aug 30, 2000 at 06:34:54PM +0200, Arno Vije wrote: > where setting up some servers for a small ISP, > they want to have a SQL database, but i`m in > doubt. Which one would you recommend, mysql or postgres? > The SQL database will be used in combination with PHP3 (or 4) > to generate dy

MySQL vs. Postgres

2000-08-30 Thread Arno Vije
Hi, where setting up some servers for a small ISP, they want to have a SQL database, but i`m in doubt. Which one would you recommend, mysql or postgres? The SQL database will be used in combination with PHP3 (or 4) to generate dynamic websites. greets, :::