In respond to Inprise/Corel MIDAS price, I thought it is a perfect time to
do some application server in MIDAS. I have heard every zip disk including a
file called 50 uses of Zip. So I thought it might be a good idea to promote
MIDAS to broad use. Definintely Inprise hold expertise on this area. And I
look forward to their contribution.
By the way, I claim that I am not Inprise staff and I have not receive any
money from them, I just love 3-tier concept.
Of course, my knowledge can not cover all tips. This thread need party.
Tips:[Number ONE]
Of course, minimize maintaince of any database engine including BDE, MS SQL
server, ORACLE, Sybase client driver.
Tips:[Number TWO]
BDE has some limit on cursor, so I heard there is only one cursor can be
opened at a time, so it is perfect to use TClientDataset to bring data local
to void the problem.
The following code just do that.
procedure CopyDataSetToTClientDataSet
(
const Source: TDataSet;
var Destination: TClientDataSet
);
var
i: Integer;
begin
Destination.Close;
Destination.FieldDefs := Source.FieldDefs;
Destination.CreateDataSet;
Source.First;
while not Source.Eof do
begin
Destination.Append;
for i := 0 to Pred(Destination.FieldCount) do
begin
Destination.Fields[i].Value := Source.Fields[i].Value;
end;
Destination.Post;
Source.Next;
end;
Destination.First;
end;
Tips:[Number THREE]
Have you ever experienced every Client/Server system, client startup that
startup can take a while depends on the database system you use and network
traffic, for Sybase Adaptive Server 11.9.2 it will take 5 seconds on my
side. If you use MIDAS, if you let application server maintains the
connection to database server, for client startup, the time spend just try
to connect to application server, no other stuff, it will usually take less
than one seconds. It is much much faster.
Thank you for your time to read this thread. And I will try to offer more
tips.
And I look forward to read your tips.
Best Regards
Leigh Wanstead
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
