http://www.perlmonks.org?node_id=314074


in reply to SQL Crosstab, a hell of a DBI idiom

Given that only 9 records in your database can generate 600 lines of SQL, what happens when you're crosstabbing databases of millions or even tens of millions of rows? From experience with Oracle, ~8000 lines was about the limit for parsing. If you've got, say, 50-100 distinct values in each of 4 dimensions (arranged 2x2) you're looking at millions of lines of SQL are you not?

rdfield