[DUG] List working?

[Jeremy Coulter]

Actually Traci, have to disagree with you about Access.
We use it with our applications that are recording live data, sometimes a 
record every less than a second or there abouts, and people are producing 
reports on the same database, and they are quite bigish in some cases too, 
and we dont really notice, and clients dont report any, performance issues 
in these situations.
Ok, I have used Delphi and Access since about Delphi 2, and before that when 
I used to do VB stuff...VB 3... and I know a few tricks admittedly, but the 
one one KEY thing to do with access is make sure you do regular Compact and 
Repair's. We have maintenace on our apps. run every night, and it just keeps 
on going.

BUT in saying that, I am getting concerned about the size of SOME sites, so 
we are looking at moving to MSDE or even Firebird, but I need to investigate 
the concequences of the move and how we update customers, implications of 
running these DB serves inline with other servers esp. SQLServer and MSDE 
etc.

Jeremy

-----Original Message-----
From: "Traci Sumpter" <Traci.Sumpter at opus.co.nz>
To: <grant at sitedoc.com.au>, "'NZ Borland Developers Group - Delphi List'" 
<delphi at ns3.123.co.nz>
Cc: 
Date: Fri, 10 Mar 2006 08:39:38 +1300
Subject: RE: [DUG] List working?

> PostgreSQL Is Really Great also!!!  And Yes, Access is great for one
> person
> apps, Quick and Dirty solution there.  However when you need to make it
> multi user on network there is so much that needs to be done to keep it
> reliable and still that is no guarantee either.
> 
> "Step away from the Access"
> 
> -----Original Message-----
> From: delphi-bounces at ns3.123.co.nz
> [mailto:delphi-bounces at ns3.123.co.nz] On
> Behalf Of Grant Brown
> Sent: Thursday, 9 March 2006 6:45 p.m.
> To: NZ Borland Developers Group - Delphi List
> Subject: Re: [DUG] List working?
> 
> Hi David,
> 
> >2. Trying to move to Firebird, but after using Access for most things,
> >asking myself why?
> >3. Project is a simple C/S app, scaling from 1 machine to 50, possibly
> >without server.
> 
> >Having to really convince myself that Firebird is a good idea: Access 
> >is so much easier for a relatively small app...
> 
> 
> If your going to move to c/s with 50 users then MS Access is a really
> really
> bad choice.
> 
> MS Access is just a desktop DB, the performance goes through the floor
> after
> about 5 users logged in.
> 
> Like you I started with MS Access but soon found out it was a big
> mistake.
> 
> Just a tip, FireBird is really good, but NexusDb is brilliant and would
> be
> my first choice.
> 
> Anyway just my 2C
> 
> Regards
> Grant Brown
> >
> >
> >   
> _______________________________________________
> Delphi mailing list
> Delphi at ns3.123.co.nz
> http://ns3.123.co.nz/mailman/listinfo/delphi
> 
> _______________________________________________
> Delphi mailing list
> Delphi at ns3.123.co.nz
> http://ns3.123.co.nz/mailman/listinfo/delphi