Re: Limit select query results

"Michael Sch'nborn" <nobody@qse.ser.tre> wrote: :Is there any possibility to limit the number of results of a select :statement? : :We are working with a database with more than 300000 entries, so the :performance is slow, if all entries match the query. Because this result is :transmitted over the Network the answering time is very high. But in fact :we do only need the first data that matches the query. : :We are using INFORMIX 7 with INTERSOLV 2.5 and Visual Basic under Windows :3.11. If you use a cursor in Visual Basic you can read only the first row. What's the problem? :Anyone has any clues, tips or tricks, please help me. : :I do appreciate any kindly help! Thank you. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org