<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/
