Board index » delphi » BufferChunks to 1 on a single record query

BufferChunks to 1 on a single record query

If I have a selectable StoredProc that I know it will ALWAYS returns only
one record,

is it a good idea to set BufferChunks to 1 (on a IBDataSet)

the IBDataSet SelectSQL property is:

select * from myprocedure(:param1, :param2, :param3)

and it is going to return just 1 record, so, BufferChunks to 1 is a good
Idea ??

I'm asking that becouse the RowSize of this procedure is HUGE !  :)

Thanks!

 

Re:BufferChunks to 1 on a single record query


Many thanks Jeff.
Regards.

"Jeff Overcash (TeamB)" <jeffoverc...@mindspring.com> escreveu na mensagem
news:3CC885CA.9DE65FD3@mindspring.com...

Quote

> Anderson de Farias wrote:

> > If I have a selectable StoredProc that I know it will ALWAYS returns
only
> > one record,

> > is it a good idea to set BufferChunks to 1 (on a IBDataSet)

> > the IBDataSet SelectSQL property is:

> > select * from myprocedure(:param1, :param2, :param3)

> > and it is going to return just 1 record, so, BufferChunks to 1 is a good
> > Idea ??

> > I'm asking that becouse the RowSize of this procedure is HUGE !  :)

> Yes, in that case or just set unidirectional to true since with only one
record
> you won't be going backwards then buffer chunks isn't part of the
equation.

> > Thanks!

> --
> Jeff Overcash (TeamB)
>       (Please do not email me directly unless  asked. Thank You)
> This sad little lizard told me that he was a brontosaurus on his mother's
> side.  I did not laugh; people who boast of ancestry often have little
else
> to sustain them.  Humoring them costs nothing and adds to happiness in
> a world in which happiness is in short supply.   (RAH)

Re:BufferChunks to 1 on a single record query


Quote
Anderson de Farias wrote:

> If I have a selectable StoredProc that I know it will ALWAYS returns only
> one record,

> is it a good idea to set BufferChunks to 1 (on a IBDataSet)

> the IBDataSet SelectSQL property is:

> select * from myprocedure(:param1, :param2, :param3)

> and it is going to return just 1 record, so, BufferChunks to 1 is a good
> Idea ??

> I'm asking that becouse the RowSize of this procedure is HUGE !  :)

Yes, in that case or just set unidirectional to true since with only one record
you won't be going backwards then buffer chunks isn't part of the equation.

Quote

> Thanks!

--
Jeff Overcash (TeamB)
      (Please do not email me directly unless  asked. Thank You)
This sad little lizard told me that he was a brontosaurus on his mother's
side.  I did not laugh; people who boast of ancestry often have little else
to sustain them.  Humoring them costs nothing and adds to happiness in
a world in which happiness is in short supply.   (RAH)

Other Threads