Have been playing today and have decided the best way is to use sockets to connect between tier 2 and tier 3 and pass a stream to a kbmMemTable. This works really well for small to medium sized datasets, but bigger ones can be slow, i.e around 1 minute for 30K+  records.

 

Has anyone else done this in the past? Any way to speeds this up, or would I be better to send XML between sockets? The XML file would be around 30Mb anyway which I would imagine would be slow too.

 


From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of James Sugrue
Sent: Monday, 16 February 2004 8:35 a.m.
To: [EMAIL PROTECTED]
Subject: [DUG] n-Tier Architechure advice

 

Morning all,

I am about to upgrade an app that has a BDE/Paradox backend.

In the new app I want a UI layer, data class/business rules layer, a physical data layer, and another layer which talks to another third party app which is the source of the data.

I was thinking of using XML to talk between tiers 2 and 3, and using ClientDataSets to represent the data in tier 2.

I was just after some advice on how other people do n-tier apps, pit falls etc. Maybe a URL or two with examples would be good to get me started. I only use Pro level Delphi, so Midas etc isn’t an option at this point.

 

 

Cheers

 

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

Reply via email to