I am the author of the package SQLiteDF for R (a statistical package),
some sort of sqlite backed "data set". It's "raison d'etre" is to deal
with very large datasets, which could be tables with thousands of
columns. I am not much on the infinite length sql statement, but I
need lots of columns in the result. I plan to hack my way into
extending the syntax to something like
select col1 ... col1000000 from table
which is shorthand for select col1,col2,col3,..., col1000000. So a
result set with lots of columns would be very nice.
Thanks,
M. Manese
On 5/10/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
I'm looking for an upper bound on how big legitimate
SQL statements handed to SQLite get to be. I'm not
interested in contrived examples. I want to see
really big SQL statements that are actually used in
real programs.
"Big" can be defined in several ways:
* Number of bytes of text in the SQL statement.
* Number of tokens in the SQL statement
* Number of result columns in a SELECT
* Number of terms in an expression
If you are using really big SQL statements, please
tell me about them. I'd like to see the actual
SQL text if possible. But if your use is proprietary,
please at least tell me how big your query is in
bytes or tokens or columns or expression terms.
Thanks.
--
D. Richard Hipp <[EMAIL PROTECTED]>
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
