Thanks guys.
In summary :-
1. All the usual problems of changing from ISAM to SQL
2. BDE threading not an issue if each user has a seperate connection
3. Sockets is fastest connection method (I dont think the stalling is in the
connect so I dont think the host resolution has any bearing)
4. Switching from BDE to IBO or IBX or DbExpress is a good(ish) idea.
The discussion has tickled my memory and I feel that I used master/child
linked tables/queries more than I should. (They were new!)
I wonder if the Midas caching of the master dataset is forcing full
population of all the child datasets.
One of the datasets also has a couple of blob fields so that could also be
causing overwork.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Peter Speden
Sent: Friday, September 07, 2001 12:24 PM
To: Multiple recipients of list delphi
Subject: Re: Re: [DUG]: Midas performance and maybe BDE Threading
<snip>
>> Which MIDAS connection method are they using Sockets, DCOM,
WebConnection?
>> Sockets is the fastest. If sockets then check that the SCKTSVR has the
>resolve
>> host names set off.
>
>Sockets. - I dont think it has resolve hostname turned off tho.
>
Turning it off will make it way better on resolving the host name (we went
from
2-3 seconds down to 1/5 a sec). This is just to get the connection between
the client and the server nothing to do with the RDMs.
>> Are the Remote Data Modules (RDM) in the server all opened at the start
or
>opened
>> as required. If opened as required are the RDM's broken into logical
>smaller
>> groups ie Order RDM containing the Order header and order details etc.
>
>RDM's are opened as required. There are 2 RDM's per client - one for the
>app, and one for the reports. the app one is _HUGE_. That might be the
>problem.... possibly.
>
Can guarantee that this is your problem. The SharedConnection is probably
what
you need. D6 has made this easier and has a demo of it. D5 you need to
look
at the Distribucon site I mentioned
>> The BDE will suffer under MIDAS if there is a TDatabase and TSession per
>RDM
>> if there are likely to be more than 60 open at a time (we actually found
>that
>> this was lower like around 25) and will lock clients. I would strongly
>recommend
>
>It appears to lock at about 5 clients, I think. Basically, not even close
to
>25, let alone 60.
>
Yep, and there is no resolution for this.
>> that IBX or IBO is used to avoid the BDE for MIDAS, unless they want to
>use
>> the SharedConnection methods in the RDMs.
>
>Hmmm, didn't look at shared connection - I'll have a look.... There is
>currently only 2 conections from each client back to the server (ie, one
for
>the main one, and one for the reports when its loaded)....
>
> > I would suggest that you look at http://www.distribucon.com for other
>tips relating
>> to MIDAS. The Shared Connection information can be found there.
>
>Cheers.
>
>> IBX updates are available from
>http://codecentral.borland.com/codecentral/ccweb.exe/author?authorid=102
>>
>>
>> IBO is at http://www.ibobjects.com/
>
>IBX and IBO were not options at the time, as it may be need to be ported to
>Oracle at a later date :( Hence why the BDE (not my first choice, either -
I
>was gunning for IBX at the time)
My suggestion would still be to use either IBX or IBO. If it is to be
ported
to Oracle later just write an Oracle MIDAS app server. I converted the app
I was working on to IBX in about 1-1/5 weeks.
Either that or upgrade Delphi to 6 and use DBExpress.
In my experiance when someone says it will be ported to xxxx it never
happens,
and if it does, with MIDAS your not looking at that much work. Then the
only
issue is having to update two servers, but I suspect that will give you less
headaches than using the BDE.
Have fun.
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
