Hi Graeme

I see that you are assuming the other application is doing a similar
query - it may infact not be doing a query at all and doing a read of
its own index record to retrieve keys to the JOB.ORDER file, all within
databasic.

If you really want to do the query you are trying above, then (as said
above) creating an index will be best - unless you can find out what
the other application is doing to get at the data so fast, then maybe
that would be the best thing to do....

rgds
Symeon

HASH.HELP
File size is in good shape (535,333 real vs 579,653 recommended)
Also the fsperation is spot on.
When you see something modulo = 1001 and recommend modulo = 579653 (or
even module = 1 recommend modulo = 535333 - i've seen stuff like this
before) you know you have a problem.
So, your file is in pretty good shape, however it is about 10%
undersized. Depending on speed of growth, you will need to do some file
maintenance.
FILE.STAT is just that, file statistics. Groups is useful because you
can see if you are getting clumping in the groups. Again, you are in
decent shape, but indications of file growth will be necessary.
With that said, this isnt your smoking gun. As other posters pointed
out, creating an index, checking if you are using the file remotely
from other server are better places to start.
HTH
Rob

Exactly.. so databasic is an acess mechanism that doesnt require
indexes of the same type as I do using Retrieve.

Ive created the index now.. and it has fixed the problem - as expected.

I now need to investigate Databasic.
thanks very much.
Graeme