J.R, --I'd suggest you check out URL: http://www.sqlite.org/limits.html --joins are typically limited to 64 tables
--Assuming you (CAN) define a database with >1000 tables, IMHO, this is a fairly unconventional design strategy, if rarely needed -- some would say this is inadvisable. Typically this sort of structure is addressed via a normalization of the schema, such that 'cities' are stored as record wise tuples within a larger relational scheme. ...just a thought.. cheers, Joe On Fri, Jan 23, 2009 at 12:55 PM, J. R. Westmoreland <j...@jrw.org> wrote: > Can someone tell me how many tables a given database can hold. > > I'm looking at an initial design of an application that could have a table > of data for each city in a state. This could be possibly more than a > thousand tables. > > With that many tables how would the performance of the database be > effected? > > > > Thanks, > > J. R. > > > > > > -------------------- > > J. R. Westmoreland > > E-mail: j...@jrw.org > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- -------------------------------------------------------------------------- Joseph Glassy Research Analyst/Programmer University of Montana NSF EPSCoR Program Davidson Honors College Room 013 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
