At 14/05/2002 11:06 AM, you wrote:

> > The engine writes to the database on SELECT as well. So turn off
> > Forced-Writes (if they are on) and you should see an improvement.
>
>I would never encourage people to set Forced Writes Off in a windows
>environment,

In this case, it's an acceptable answer. Because, the original post
mentioned that it was running on a Linux system. Forced Writes works great
on Linux(too bad we can't say the same for Windows).


Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)