Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 4 of 4 total |
DBISAM 4: delay when changing range/index on filtered dataset |
Thu, Jan 25 2007 6:17 PM | Permanent Link |
"Monte Etherton" | Good day!
My scenario and question: MyApp, Using XP and DBISAM 4.24.1 (non-client-server) with data on a remote shared XP peer2peer drive... A MyApp user may select a tab to change the view on data, this simply applies a range with corresponding index (ie current jobs, previous jobs, jobs coming in). Record count may be from 0 to 500 depending on range set. A user may also "zoom in" to more specific data by setting a filter (ie. my jobs). Note: All data needs to be live so don't need SQL solutions please. Problem: When a user has set a filter, and then changes his view, there is a long delay, like 5 seconds or more. Without the filter, no delay. If user turns off filter, then changes view, then resets filter, also no delay. No delay when setting filter alone, either. I tried changing my code so the filter is turned off before the range/index reset, then turned back on...did not help. The delay seems to be when the filter is turned back on, but only when doing a range/index reset in the same code block. I then tried turning off the filter before the range/index reset, and turning it back on in OnAppIdle. This works without the delay. Is there another way I can avoid the delay without the OnAppIdle hack? Or is that an OK thing to do? thanks, Monte automated concepts |
Wed, Jan 31 2007 8:50 AM | Permanent Link |
"Monte Etherton" | From the lack of response, my guess is that this issue is not something
anyone else has experienced. I'll spend some more time studying my code to see if I can find any other cause, but for now, the delay is gone.... -Monte "Monte Etherton" <monte[at-sign]automatedconceptsca[dot-char]com> wrote in message news:4812C64B-AB27-4049-91ED-BB2CC0EE06EA@news.elevatesoft.com... > Good day! > > My scenario and question: > > MyApp, Using XP and DBISAM 4.24.1 (non-client-server) with data on a > remote shared XP peer2peer drive... > > A MyApp user may select a tab to change the view on data, this simply > applies a range with corresponding index (ie current jobs, previous jobs, > jobs coming in). Record count may be from 0 to 500 depending on range > set. > > A user may also "zoom in" to more specific data by setting a filter (ie. > my jobs). Note: All data needs to be live so don't need SQL solutions > please. > > Problem: When a user has set a filter, and then changes his view, there is > a long delay, like 5 seconds or more. Without the filter, no delay. If > user turns off filter, then changes view, then resets filter, also no > delay. No delay when setting filter alone, either. > > I tried changing my code so the filter is turned off before the > range/index reset, then turned back on...did not help. The delay seems to > be when the filter is turned back on, but only when doing a range/index > reset in the same code block. > > I then tried turning off the filter before the range/index reset, and > turning it back on in OnAppIdle. This works without the delay. > > Is there another way I can avoid the delay without the OnAppIdle hack? Or > is that an OK thing to do? > > thanks, > > Monte > > automated concepts > > > > > > |
Wed, Jan 31 2007 4:10 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Monte,
<< From the lack of response, my guess is that this issue is not something anyone else has experienced. I'll spend some more time studying my code to see if I can find any other cause, but for now, the delay is gone.... >> Sorry about the non-response. I think that I was going to check and see if you also posted this in the DBISAM newsgroup and then forgot about it. Does the problem occur if the data is local ? -- Tim Young Elevate Software www.elevatesoft.com |
Fri, Feb 2 2007 1:08 PM | Permanent Link |
"Monte Etherton" | No problem...for some reason I didn't have the DBISAM newsgroups displaying
in my reader, so I will do some more testing and re-post over there. The problem is not noticeable on local data, but I have not tried to run a "stop-watch" on it to see if the hack is still faster there too. "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message news:7C84CDE9-DCAF-4A98-9D78-11A6C5B1E485@news.elevatesoft.com... > Monte, > > << From the lack of response, my guess is that this issue is not something > anyone else has experienced. I'll spend some more time studying my code > to see if I can find any other cause, but for now, the delay is gone.... > >> > > Sorry about the non-response. I think that I was going to check and see > if you also posted this in the DBISAM newsgroup and then forgot about it. > > Does the problem occur if the data is local ? > > -- > Tim Young > Elevate Software > www.elevatesoft.com > |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |