Jeremy
Yes everybody has a story where #THEY# got a dog to do tricks, It still
doesn't alter the fact that its a dog
> BUT in saying that
And your point is?
Neven
Jeremy Coulter wrote:
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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>, "'NZ Borland Developers Group - Delphi List'"
<[email protected]>
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: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] 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
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi
_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi
_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi
--
Neven MacEwan (B.E. E&E)
Ph. 09 620 1356 Mob. 027 4749 062
New Address Details
===================
MWK Computer Systems
1 Taumata Rd
Sandringham
Auckland
Ph 620 1356
Fx 620 1336
begin:vcard
fn:Neven MacEwan
n:MacEwan;Neven
email;internet:[EMAIL PROTECTED]
tel;work:649 620 1356
tel;fax:649 620 1336
tel;cell:0274 749 062
version:2.1
end:vcard
_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi