Subject RE: [firebird-support] Not able to retrieve the data from Table
Author Svein Erling Tysvær
>I am using the FlameRobin tool to execute the query.
>I write the select query like select first 100 * from XXX , I am able to get the result.
>But when use one more query select first 110 * from XXX , I am not able to get the data,
>still it is in process to get the Data. I am surprise for getting another 10 extra records
>why it is taking so much time.
>I don't know where is the problem, please let me know if you have faced this type of
>problem how you resolved this.

Luckily (for me, not for you), this is a type of problem that I know virtually nothing about and that others on this list can (and hopefull will) answer much better. Still, I do have a few questions.

I assume SELECT FIRST 20 SKIP 90 * FROM XXX also is slow? I also assume you don't have any WHERE clause? Have you tried the same select on a freshly restored database (assuming it could be some corruption within the database that might or might not give an error during backup or restore)?