Subject | help needed. browsing slows down after a days work |
---|---|
Author | DennisFantoni |
Post date | 2001-12-11T12:45:08Z |
I've gotten this weird bugreport from my customer, and they have
confirmed the problem is not only one computer, but all of them.
they have an application with an interbase6 server and abt. 20
workstations.
whe a workstation is on, it shows a ib_grid that connects to a query,
typically something like select * from table (returning lots of rows)
The application works fine and browsing is quite fast, all considered.
But after 5-6 hours work, brosing becomes really really slow. Perhaps
20 times slower than at the beginning.
Does anyone have any idea what this could be? Usually my applications
start being slow, and stays so ;-) ( or starts being fast and stays
so..).
Is there something in ibo or interbase that might go slower over time?
the query for the grid loads perhaps 6000 records.
I would like some pointers as to where to look for problems. I never
used ib_grids before - the other ibobject applications that i made
were not using db-aware controls. This application was not programmed
by myself, but the programmer seems to have known the database aware
objects quite well. Still, he migt've done something wrong that
causes things to slow down.
My own idea of attacking the problem right now, is to somehow try to
get the slowing down to occour at my own computer, then to see if
there's any local memory leaks.
Dennis
confirmed the problem is not only one computer, but all of them.
they have an application with an interbase6 server and abt. 20
workstations.
whe a workstation is on, it shows a ib_grid that connects to a query,
typically something like select * from table (returning lots of rows)
The application works fine and browsing is quite fast, all considered.
But after 5-6 hours work, brosing becomes really really slow. Perhaps
20 times slower than at the beginning.
Does anyone have any idea what this could be? Usually my applications
start being slow, and stays so ;-) ( or starts being fast and stays
so..).
Is there something in ibo or interbase that might go slower over time?
the query for the grid loads perhaps 6000 records.
I would like some pointers as to where to look for problems. I never
used ib_grids before - the other ibobject applications that i made
were not using db-aware controls. This application was not programmed
by myself, but the programmer seems to have known the database aware
objects quite well. Still, he migt've done something wrong that
causes things to slow down.
My own idea of attacking the problem right now, is to somehow try to
get the slowing down to occour at my own computer, then to see if
there's any local memory leaks.
Dennis