Updating Query Table (AREV Specific)
At 14 FEB 2002 04:49:42PM Jeff Morra wrote:
I have a lot of problems, but I will start with this one. Sometimes there seems to be huge slow downs on a PC and it displays "Updating Query Table" at the bottom. We are running ARev 3.12 on a NetWare 5.1 server with the NLM. When I go into the database and run a "SELECT KY01" from the command prompt, it selects the 58 rows very quickly and then flashes the "Updating Query Table" for just a moment before returning to TCL. If I run the same select right away again, it sits at "Updating Query Table" for a long long time. Please help, I am near the end of my rope. Thanks
At 14 FEB 2002 05:49PM Victor Engel wrote:
In you environment you can define how many queries are saved for use by CTRL-F10 at TCL. The delay you are encountering happens when a new query is added to the list and consequently the oldest one is purged. If the oldest list is a big list, it may take some time to purge it.
You can eliminate this delay by setting number of saved queries to 0 in your environment. However, if you do this, old queries will not be available using the CTRL-F10 keystroke.
At 14 FEB 2002 06:42PM Jeff Morra wrote:
Victor, thank you thank you thank you thank you.. This has helped a tremendous amount. Our database is huge, and there are always reports running which do selects on some of our bigger files (2,000,000+ records), and from the moment I changed that until now the system has been running much much faster. Thanks again.