Fetching records on Firebird, produces crashes

[Guest_imported]

Hello,

I have one problem working on Firebird (Fre version of Interbase).
When I have a table or a query with many many records, for example 300000 records, when I am in the first record, and I want to go directly to the last record, I have a big problem.

The problem is that i must use the command
QR.RecNo=300000;
or the command
QR.Last;

This commands fetches all the records in the database from the actual record to the record that you want to access, and when you have 300000 records or more, the program takes some time (very long), or the program is crashed.

How can I avoid that??????

Thank you very much in advance!!!

 

[McMerfy]

Records are fetched to the memory, so maybe you are just running out of system resources?

--- markus