If you want help with your SQL. You should post it along with your question. There are a lot of really good SQL experts on here that will be able to help you.
--- On Tue, 12/9/08, jm cuaz <[EMAIL PROTECTED]> wrote: > From: jm cuaz <[EMAIL PROTECTED]> > Subject: [sqlite] SQL question with SQLite > To: sqlite-users@sqlite.org > Date: Tuesday, December 9, 2008, 9:58 AM > Hello, > > In a SELECT statement with multiple tables, is it possible > to replace > WHERE clauses used to avoid cross joins with GROUP BY + > HAVING clauses > (with the same criteria) for the same purpose (no cross > join) ? > > Are the two methods roughly equivalent in performance ? > > We ask this because we wonder why using the GROUP BY + > HAVING solution > with 7 tables instead of WHERE clauses we see big > degradation of > perforamnce (0,5 seconds against 30 minutes) + break with > "disk full" > error message . We checked the statement with GROUP BY + > HAVING against > the initial WHERE clause and are assured not to > "miss" any criteria > present in the WHERE clause. > > Thanks > > Jean-Marie > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users