Re: Pervasive SQL - Timeout

Hi There,

Thanks a lot for your answers. I already have an Index on Coupon_No.
(BTW the table as 240,000 records as opposed to my earlier figure of
24,000).

The thing that I noticed is that even in the PCC, it takes really long
to execute the query. Also, the index is a non-duplicate one. So when i
queried for Coupon_No =1 it brought back 3 rows (after a
million-gazillion years i.e.). I havent changed the indices as I am not
allowed to do that from the DDF builder.

The server processor is a little slow but not this slow. Could there be
any other reason why?

MD

.