Hi Folks, We have implemented virtual tables that have around 12K rows. Running a simple join operation on these tables takes a significant amount of time as by default joins are of order of O(n^2).
E.g. a query such as "select * from t1 join t2 on t1.name=t2.name" We tried to optimize it using xBestIndex and xFilter but to no avail. We couldn't find a way to pass the value of t1.name (for each row) to the filter of t2. Is there a way we could accomplish that? Or is there any other way to optimize join operations? Thanks in advance. We really appreciate your help! Cheers, Punit _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
