Re: [GENERAL] restricting select statements

1999-02-24 Thread Jim Mercer
> I'm working with JDBC and if I issue a broad SELECT statement, with a > good amount of records (2000) it takes quite a while to execute the > query and send the results back, even up to a minute, when I only want > about the first 100 records. If I restrict the search, it is satisfied > in a muc

[GENERAL] restricting select statements

1999-02-24 Thread Bob VonMoss
I'm working with JDBC and if I issue a broad SELECT statement, with a good amount of records (2000) it takes quite a while to execute the query and send the results back, even up to a minute, when I only want about the first 100 records. If I restrict the search, it is satisfied in a much more rea