firebird-net-provider

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.

Re: [Firebird-net-provider] select quick

[<car...@te...>]

Hello:

>     SELECT FIRST :numrows SKIP 5

Try this:

	SELECT FIRST (:numrows) SKIP 5





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

RE: [Firebird-net-provider] select quick

[Marco B. <mar...@ai...>]

Thank you... now it's working properly. =20

The Newbie

> -----Original Message-----
> From: Carlos Guzm=E1n =C1lvarez [mailto:car...@te...]=20
> Sent: Wednesday, February 18, 2004 7:49 PM
> To: Marco Brambilla
> Cc: fir...@li...
> Subject: Re: [Firebird-net-provider] select quick
>=20
> Hello:
>=20
> >     SELECT FIRST :numrows SKIP 5
>=20
> Try this:
>=20
> 	SELECT FIRST (:numrows) SKIP 5
>=20
>=20
>=20
>=20
>=20
> --
> Best regards
>=20
> Carlos Guzm=E1n =C1lvarez
> Vigo-Spain
>=20

Re: [Firebird-net-provider] select quick

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

""Paola"" <pa...@sa...> ha scritto nel messaggio
news:104...@ne......

> Sorry, Are you italian?

Yes, but if you want to talk in italian please, send me a private email.

Ciao,
Alessandro Petrelli.

RE: [Firebird-net-provider] select quick

[Marco B. <mar...@ai...>]

(Sorry for this off-topic question...)

Hi Alessandro... like Paola, I have a stored proc that needs to be improved
that way.

But I receive an error if I try to use FIRST... SKIP in a stored procedure.

Thanks in advance.

Here is the code:
--
alter PROCEDURE "sdqFORUMMSGSet_msgs"
    
(        
"_GHOST" SMALLINT,
"_ISDELETED" SMALLINT,
"_ID_SENDER" INTEGER,
"_ID_FORUM" INTEGER,
numrows INTEGER,
numfrom INTEGER
)

RETURNS
(
"GHOST" SMALLINT,
"ISDELETED" SMALLINT,
"ID" INTEGER,
"ID_SENDER" INTEGER,
"ID_FORUM" INTEGER,
"CREATED" TIMESTAMP,
"NICK_SENDER" VARCHAR(20),
"BODY" VARCHAR(2000)        
)

AS

BEGIN


    FOR
    SELECT FIRST :numrows SKIP 5
        
        "GHOST",
        "ISDELETED",
        "ID",
        "ID_SENDER",
        "ID_FORUM",
        "CREATED",
        "NICK_SENDER",
        "BODY"

    FROM
        "FORUMMSG"

    WHERE
        
        ("GHOST" = :"_GHOST" OR :"_GHOST" IS NULL)
         AND ("ISDELETED" = :"_ISDELETED" OR :"_ISDELETED" IS NULL)
         AND ("ID_SENDER" = :"_ID_SENDER" OR :"_ID_SENDER" IS NULL)
         AND ("ID_FORUM" = :"_ID_FORUM" OR :"_ID_FORUM" IS NULL)

ORDER BY CREATED desc

    INTO
        
        :"GHOST",
        :"ISDELETED",
        :"ID",
        :"ID_SENDER",
        :"ID_FORUM",
        :"CREATED",
        :"NICK_SENDER",
        :"BODY"
                  
    
  DO
  BEGIN
    SUSPEND;
  END


END
--


> -----Original Message-----
> From: fir...@li... 
> [mailto:fir...@li...] On 
> Behalf Of Alessandro Petrelli
> Sent: Wednesday, February 18, 2004 12:59 PM
> To: fir...@li...
> Subject: Re: [Firebird-net-provider] select quick