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