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

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

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

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
>