[sqlite] Re: number of rows in a table

2008-01-14 Thread Igor Tandetnik
Bob Rossi [EMAIL PROTECTED] wrote: With sqlite (or any database 'mysql') if you have a table, can you insert thousands, millions, billions,... of rows? Yes, though billions is pushing it for an embedded database like SQLite. Also, say you index one of the columns, and there are millions of

Re: [sqlite] Re: number of rows in a table

2008-01-14 Thread Bob Rossi
On Mon, Jan 14, 2008 at 03:54:36PM -0500, Igor Tandetnik wrote: Bob Rossi [EMAIL PROTECTED] wrote: Also, say you index one of the columns, and there are millions of rows in the database, but each unique index has 100 items. If you search for a particular index, what is the Big O notation