On Mon, Jan 16, 2006 at 04:11:47AM -0600, michael munson wrote:
> >At the worst that would be around 6 million columns on a property table.
> >I've not used SQLite with tables that large before
> >so I'm not sure if searching with 2 index values (name, and object its on)
> >is going to be slow.
>
> Heh, that should obviously read '6 million rows' . Sorry, its early.
Unless your rows were exceptionally wide, that shouldn't be difficult to
handle at all.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461