Sr. Web Developer
mediabistro.com
US-NY-New York

Justtechjobs.com Post A Job | Post A Resume

Comments for: glodt20020212

Message # 1023069:
Date: 11/29/04 02:29
By: Oliver
Subject: RE: Firebird vs. PostgreSQL vs. rest of world..

Hi

I have set up a postgres database running on Mandrake Linux 10. The database captures between 10000 and 15000 records per month - there are over 50000 records in some of the tables. It runs on a Pentium 4 2.66 Desktop and serves 40 to 50 users. The server is on a local LAN and copes very well performance wise. There was a problem running it across a slow speed WAN link 256K. Locally works great though. Use PL/SQL as much as possible (better than firebird stored procedures which dont seem to have the ability to use handy functions like 'quote_ident') and apply views wherever possible also use good indexes and you cant go wrong.

Hope this helps
Cheers

Previous Message | Next Message


Comments:
configure postgresql with phpmelda06/08/05 08:05
Interbase.so can not be generatedvins01/13/05 04:54
RE: Firebird vs. PostgreSQL vs. rest of world..Oliver11/29/04 02:29
RE: How configure php_interbaseWimpie Vermaak05/16/03 05:54
Control de Errores en InterBase & PhpJaime Vera Sobino02/11/03 12:02
RE: How configure php_interbase soJose Romero11/15/02 08:59
computerwinga11/06/02 09:31
RE: How configure php_interbaseMaxim Yemelyanov10/14/02 06:34
RE: how to configure interbase in phpyves10/13/02 14:02
RE: PHP e InterbaseSidney10/08/02 09:16
how to configure interbase in phpDaniel09/17/02 16:44
About Interbase SQL: SELECT ... LIMITHellion09/09/02 12:35
GDB File ExtensionDick Lamborn08/22/02 15:11
How to connect to another databasemohsen08/15/02 04:14
help Interbasemohsen08/15/02 04:05
PHP e InterbaseFelipe08/14/02 14:04
multimedia databaseHIRNANI08/13/02 22:53
How can launch the phpMyAdmin on easyphpDario Valenzuela08/13/02 14:59
RE: How configure php_interbaseSaci08/12/02 21:37
RE: How configure php_interbaseLarissa Oliveira08/04/02 16:24
RE: How configure php_interbasemazz07/26/02 19:29
optimising a queryS. Breton07/18/02 16:00
RE: interbase vs. mysqlJohn Sparrow07/13/02 10:30
RE: HELP! Firebird vs. MySQLJohn Sparrow07/13/02 10:20
RE: interbase databases listJohn Sparrow07/13/02 10:14
interbase databases listDiZEM07/11/02 05:33
Great DealIndria Suta07/10/02 23:39
RE: How configure php_interbaseyves07/07/02 13:35
How configure php_interbasePaulo Antiuera07/02/02 15:53
RE: HELP! Firebird vs. MySQLSteinn07/02/02 15:22
RE: interbase vs. mysqlLuis Gonzalez07/01/02 13:52
Firebird vs. PostgreSQL vs. rest of world..Thomas Kirchtag06/29/02 07:27
Problems Inserting A New Recordcs_bloo06/29/02 06:06
RE: 2 problems solved.S. Breton06/27/02 15:19
2 problems from a newbie to php!S. Breton06/27/02 12:50
RE: arithmetic exceptionTas06/24/02 16:45
arithmetic exceptionLuciano Mittmann06/19/02 09:05
RE: pipe in bottle holes!John Sparrow06/16/02 09:07
RE:Slow Outer join in FirebirdJohn Sparrow06/16/02 09:05
RE: PHP with Interbase on IIS5John Sparrow06/16/02 08:55
RE: How to perform a select statementronald06/06/02 07:08
RE: HELP! Firebird vs. MySQLronald06/06/02 06:58
RE:Slow Outer join in FirebirdJohan Jordaan05/30/02 04:49
pipe in bottle holes!Johnny Keplinger05/24/02 13:54
can't goto http://php4win.de/Anan Ananthasri05/17/02 14:28
PHP with Interbase on IIS5Anan Ananthasri05/17/02 13:47
HELP! Firebird vs. MySQLCheri05/10/02 13:33
How to perform a select statementJoaquin Cano05/07/02 04:59
RE: Can't install IB 6 on RedHat LinuxGrandBob04/24/02 10:37
RE: interbase "sql error code 901"chris04/18/02 09:16
RE: interbase "sql error code 901"chris04/17/02 16:45
RE: postgresql vs interbase/fbFlying04/14/02 06:36
PEAR support to IntebaseClaudio Pereira04/08/02 21:45
Can't install IB 6 on RedHat LinuxSteve Vai04/04/02 17:26
RE: interbase vs. mysqlBrent04/04/02 14:59
RE: interbase "sql error code 901"bleuzen04/04/02 10:39
interbase "sql error code 901"Lemming03/27/02 05:02
RE: interbase vs. mysqlRob Segerink03/21/02 08:58
RE: Connecting to Interbase on Windowsyves03/13/02 12:39
RE: Connecting to Interbase on WindowsFlint Dwiggins03/11/02 20:08
RE: Error configuring php-interbaseyves03/07/02 13:12
Error configuring php-interbaseS.H.Setyawan03/05/02 22:49
RE: Can't insert a recordyves03/04/02 17:05
RE: Congratulationsyves03/04/02 17:02
RE: Connecting to Interbase on Windowsyves03/04/02 16:56
CongratulationsYoussef & Rachid03/04/02 04:12
Can't insert a recordBram Wielemaker03/04/02 02:24
Connecting to Interbase on WindowsCharles Alwakeel03/03/02 08:38
can u send this to meDavid Douglas02/25/02 21:49
search results in many pagesBrazilian Joe02/25/02 10:28
postgresql vs interbase/fbniyogi02/21/02 01:57
RE: How to connect Borland Interbase with MySyves02/19/02 12:44
RE: interbase vs. mysqlyves02/19/02 12:42
Apache + Php + RpmMaruscya02/19/02 06:29
Firebird ScalabilitySquidge02/17/02 19:46
RE: interbase vs. mysqlyves02/16/02 14:16
RE: How to connect Borland Interbase with MySQL yves02/16/02 14:04
RE: interbase vs. mysqlRodrigo02/15/02 16:00
How to connect Borland Interbase with MySQL Richard Zhang02/14/02 18:37
interbase vs. mysqlRoy02/14/02 18:15
 

If you are looking for help, please post on the appropriate forum here. Your questions will be answered much more quickly.

Add A Comment:

Name:

Email:

Subject:

Message:

To reduce spam posts, messages are now manually approved

You are not [logged in]. That means your account will not get credit for this post.