Subject Re: [ib-support] IB Server is SLOW!!!!!!!!!!!!
Author GreatDayDan
Good Morning!

TTables were not my idea, but they are on the base
class and cannot be removed (at least until I can
build in a base query to replace it.)

Only the main form is auto created. Most of the
rest have a class procedure for creating.

Most of the data components are Info Power
components. Will these convert to IBObjects? The app
is written in D4 and some of the 3rd party stuff would
have to be replaced with their D5 versions if I needed
to move to D5.

Thanks...Dan'l


--- Daniel Rail <daniel@...> wrote:
> At 07/03/2002 08:43 AM, you wrote:
> > The app is using TTables (not my idea, someone
> else wrote the
> >app). I have tried to make sure that all tables and
> queries are
> >closed when the app starts and when the forms (~600
> of them) are
> >created.
> >
> > The owner is pulling her hair out and is ready
> to trash the whole
> >thing and buy something else.
> >
> > What else can I try? What can I look at to find
> the problem?
>
> The bad news is that if you are using TTable and
> BDE, you are going to have
> performance problems. Using the BDE and TTables
> means that all of the data
> is transferred to the BDE buffers, and this you
> don't want. The best thing
> you can do is to dump the BDE and try IB Express or
> IB Objects
> (www.ibobjects.com) for better performance.
>
> Second thing I noticed is that you referenced
> creating all the forms, one
> suggestion DON'T, create them as needed and
> destroyed when not needed, if
> you already do this then disregard. This helps to
> reduce the consumption
> of computer resources and memory. If both the
> application and server are
> running on the same computer, this might be a good
> starting point to remedy
> the problem, and to change the connectivity
> components.
>
> I didn't have that much problems to convert from BDE
> to IB Objects, it went
> relatively smoothly.
>
>
> Daniel Rail
> Senior System Engineer
> ACCRA Group Inc. (www.accra.ca)
> ACCRA Med Software Inc. (www.accramed.ca)
>
>


=====
____________________________________
Every day is a Great day, but
some days are GREATER than others!

__________________________________________________
Do You Yahoo!?
Try FREE Yahoo! Mail - the world's greatest free email!
http://mail.yahoo.com/