[Dbix-class] Regarding Oracle's 1000 element limit in IN clause

Marc Logghe logghe.marc at gmail.com
Mon Oct 24 09:12:00 GMT 2011

I often use sqlite for these kind of purposes. Works like a charm.

On Mon, Oct 24, 2011 at 10:48 AM, Matija Grabnar <matija at serverflow.com>wro=

> You have another possibility: create the temporary tables in another
> database. This database can be on your OWN server, so the HUGE company
> doesn't even have to know about it.
> If you were to download the full resultset and do the searching in Perl y=
> would in effect be doing the
> same thing, except your database would be in your RAM, and you would be
> using Perl instead of SQL
> to search for it. For large datasets (which this seems to be) a database =
> the local server is more efficient than doing it all in RAM.
> ______________________________**_________________
> List: http://lists.scsys.co.uk/cgi-**bin/mailman/listinfo/dbix-**class<ht=
> IRC: irc.perl.org#dbix-class
> SVN: http://dev.catalyst.perl.org/**repos/bast/DBIx-Class/<http://dev.cat=
> Searchable Archive: http://www.grokbase.com/group/**
> dbix-class at lists.scsys.co.uk<http://www.grokbase.com/group/dbix-class@lis=
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20111024/d36=

More information about the DBIx-Class mailing list