I think I may have solved this problem.
I changed
SET REFRESH TO 1, -1
This forces all data to be read from disk.
It seems to be working, fingers crossed.
Thanks for everyones help,
Kent
___
Post Messages to: ProFox@leafe.com
Subscription Maintenanc
Could there also be a great increase in network traffic at that time? Someone
downloading a big file?
--- On Wed, 11/11/09, Michael Madigan wrote:
> From: Michael Madigan
> Subject: RE: Seek slow
> To: "ProFox Email List"
> Date: Wednesday, November 11, 2009,
rom: Kent Belan
> Subject: RE: Seek slow
> To: "'ProFox Email List'"
> Date: Monday, November 9, 2009, 9:15 AM
> Hello Dave and all,
> I have not received a Profox email for over a week.
> This morning I got about 250 emails but all dated today.
> I even
: 'ProFox Email List'
> Subject: RE: Seek slow
>
> The table needs to be reindexed maybe as lots of the entries
> are in the "overflow" areas?
>
> We get this stalling quite a lot if the table has had lots of
> sequential (non random) keys added thus making
4 matches
Mail list logo