On Windows, timing sending the results to a file:
sqlite3 your.db "SELECT * FROM trend_data" > foo.txt
On a 2.0 GHZ P4 I get 50,000 rows/second, which is not bad considering
it's a 5 year old machine and sqlite3 was not compiled with much
optimization.
Any new machine should be twice as fast.
> time sqlite3 your.db "SELECT * FROM trend_data" | wc -l
>
> Run the command more than once, as the first timing is always slower.
____________________________________________________________________________________You
snooze, you lose. Get messages ASAP with AutoCheck
in the all-new Yahoo! Mail Beta.
http://advision.webevents.yahoo.com/mailbeta/newmail_html.html
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
