Re: Selecting first N rows of a result set

2006-01-09 Thread J . English
Bernt M. Johnsen wrote: Hi, Please post your SQL and JDBC code. That might make it possible to us to see whay you have performance problems. The SQL is very simple: SELECT * FROM system_log_view (although there may be optional search and ordering criteria as well, as specified by the user,

Re: Selecting first N rows of a result set

2005-12-15 Thread Bernt M. Johnsen
Hi, Please post your SQL and JDBC code. That might make it possible to us to see whay you have performance problems. Generally in JDBC, the way to limit the number of rows returned from a query is stmt.setMaxRows(N). [EMAIL PROTECTED] wrote (2005-12-15 14:46:13): I know this has been asked