Query executes faster in grid mode than - TechRepublic
General discussion
March 9, 2000 at 01:29 AM
a_adie

Query executes faster in grid mode than

by a_adie . Updated 25 years, 5 months ago

Hello,everyone!!

There is a query which when executed in the grid mode(ctrl+d) takes approx 0.02 seconds(about 21,000
rows) But when I execute in the text mode, it takes about 0.40 seconds!!
Why is this difference?
Also, when the recordsfrom this table are read from a VB application, they are equally slow (as in the text mode!)
Why is it so slow on the text mode & relatively faster in the grid mode?
Has anyone got any idea on ‘Firehose’ style cursor ?(which may speedup access of data in the VB application)

Rgds,
Adie

This discussion is locked

All Comments