Hello, Currently, we are using lucene to do full-text search (may be we will switch to FTS3). And we inject all the ids returned by lucene in prepared statements to load the data. But we have to check that the ids collection size is not greater than SQLITE_MAX_VARIABLE_NUMBER (999 by default) or split the query accordingly with all the related problems (duplicates, sort, ...). Is there any impact if I increase the SQLITE_MAX_VARIABLE_NUMBER? Should I use a temporary table instead?
Regards. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
