RE: [DUG] n-tier Architecture

[David Brennan]

We haven't had a problem using Client Datasets (and therefore Midas) in Delphi 5 and we have some reasonable size sites using it on fairly large databases. However we aren't operating as 3 tier and we don't use the providers for updating - they are only used one way for data retrieval, we take care of database updating ourselves.

 

The only problem we did have was with Midas getting upset and occasionally crashing when the user was saving lots of 1-2 Megabyte bitmaps into a dataset. We convinced them that was a bad idea (and behind the scenes began converting bitmaps to PNGs which were only 50KB in case they kept doing it) and the problem went away.

 

David.

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Sulav Giri
Sent: Wednesday, 7 April 2004 10:32 AM
To: NZ Borland Developers Group - Delphi List
Subject: Re: [DUG] n-tier Architecture

I would advise against using MIDAS (at least the Delphi 5 version). It is a resource hog!  Queries can take ages to run and memory usage goes through the roof!

 

-Sulav

James Sugrue <[EMAIL PROTECTED]> wrote:

Morning all.

 

I have a client who currently has an application written in Delphi which I look after. The db is paradox and is getting a bit large for this. I am looking at upsizing to an SQL server.

 

I am looking at an n-tier approach, probably 3 tier and would like to keep the DB Layer independent of DBMS. I would have to upgrade to Delphi Enterprise to use MIDAS, is there any other (cheaper) options that other people have used?

 

The other option I have considered would be to use an OO persistence layer to persist the data to whatever DBMS, but havent done this before, so I am guessing there would be a learning curve.

 

Advice?

 

TIA

 

 

_______________________________________________
Delphi mailing list
[EMAIL PROTECTED]
http://ns3.123.co.nz/mailman/listinfo/delphi

---

Do you Yahoo!?
Yahoo! Small Business $15K Web Design Giveaway - Enter today

_______________________________________________
Delphi mailing list
[EMAIL PROTECTED]
http://ns3.123.co.nz/mailman/listinfo/delphi