DBI

Scott Penrose scottp at dd.com.au
Fri Apr 2 01:29:55 CST 2004


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

One further suggestion.

LIMIT and OFFSET mean that you are doing a search EACH time. If that is 
slow you will be a very long time.

CURSORS is actually what you want.

You open a CURSOR and store a SELECT

You can then open it again and read a few more rows, come back later 
and read a few more rows...

More efficient - also these ARE supported under Postgres AND MySQL :-)

Scott

On 02/04/2004, at 5:13 PM, Alfie John wrote:

> Thanks for the help guys!
>
> After a lot of searching and ircing, it looks like this is a common
> problem with no db-independent solution, but the DBI guys are looking
> into it.
>
> I think because I am open-source oriented, I will take the
> mysql/postgresql approach with LIMIT and OFFSET.
>
> int 20h;
> Alfie John
>
>
>
>
- -- 
Scott Penrose
Open source developer
http://linux.dd.com.au/
scottp at dd.com.au

Dismaimer: Open sauce usually ends up never coming out (of the bottle).

Please do not send me Word or PowerPoint attachments.
See http://www.fsf.org/philosophy/no-word-attachments.html
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (Darwin)

iD8DBQFAbRZ4DCFCcmAm26YRApg8AJ9VMDhGjtNoY67qA20YPVvuoe5JUwCdEFkg
bhq//mYvzDJK2sMlOMAHY4c=
=n4m5
-----END PGP SIGNATURE-----




More information about the Melbourne-pm mailing list