The syntax for limiting the results in firebird is: select first x, y from table This is very recommended as a best pratice in development process. By the way, 2000 records aren't too much, in my point of view. If your table don't have much columns and your network should be fast, maybe, there's a h...