Re: [Firebird-net-provider] select quick

[Alessandro P. <pet...@in...>]

""Paola"" <pa...@sa...> ha scritto nel messaggio
news:104...@ne......
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_0000_01C3F617.5C5AA170
> Content-Type: text/plain;
> charset="us-ascii"
> Content-Transfer-Encoding: 7bit
>
> Hi all!
>
> Sorry my English, I'm Italian
>
> I would like to know, how optimize "Select".
>
> Example, if I have 10000 lines, "Select *" in Datagrid uses 30 second.
>
> Is there a way faster to do it?

Paola,

you need to limit your query by using "SELECT FIRST n SKIP j * FROM
MYTABLE", where n is the number of record you want to select and j is the
number of record you want to skip.

Ciao,
Alessandro Petrelli.