Getting Started with dBASE - Is this speed normal

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Is this speed normal

Mekson Ossai

2006-11-21, 7:13 pm

Please advise me. A report of about 5mb size takes 1 hour to open. I am asking if it is normal or not.

Mekson

David Kerber

2006-11-21, 7:13 pm

In article <9N1MOKWDHHA.1212@news-server>, megameks@yahoo.com says...
> Please advise me. A report of about 5mb size takes 1 hour to open. I am asking if it is normal or not.

It would depend on the query that the report uses, but in general I
would say "no". You probably need some indexes to improve the query
speed. Any field that is used for sub-setting or sorting records, or
for joining a table to another table are candidates for indexes.

--
Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).

Sponsored Links