[Dbix-class] Regarding Oracle's 1000 element limit in IN clause
matija at serverflow.com
Mon Oct 24 08:48:30 GMT 2011
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
you 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
on the local server is more efficient than doing it all in RAM.
More information about the DBIx-Class