On 14 Jul 2010, at 8:22pm, Igor Sereda wrote: > I would agree in other cases, however, in our app, the schema is dynamic and > depends on the user data. Normally, we have about 200 tables with two or > three columns each, with indexes almost on each table. Queries with > lots-of-joins are also constructed dynamically, and we found SQLite to be > pretty effective in selecting optimal join algorithm based on ANALYZE > results.
Fair enough. You seem to be dynamically generating your schema, which is unusual for a SQL user. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users