Hi OC,
Your problem description smell like an IO contention. BTW, this is not FB
exclusive, all database will have the same kind of behaviour.
If the is no index for the where condition, you force a table scan (read all
the table rows to validate the condition). If the row data in memory, this
Hi there,
for years and years, we happily use FrontBase. Lately though we are bumping
into somewhat weird behaviour: we observe inexplicably long fetches, even with
tables which are not extremely big, no joins, trivial conditions. What's even
more intriguing is that in sql92, it was much faster
