http://www.netvouz.com/postasaurus/tag/database?feed=rss postasaurus's bookmarks tagged "database" on Netvouz http://www.codeproject.com/cs/database/EmbeddedFirebird.asp An example that shows how Firebird database excels in embedding. programming > Firebird postasaurus Mon, 12 Feb 2007 10:12:22 GMT http://www.databasejournal.com/features/postgresql/article.php/3437821 There is an understanding in the database world that using a 'SELECT DISTINCT' SQL query is not a good idea, because it is essentially getting duplicate rows out of the database and then discarding them. Usually it's better to rearrange the 'WHERE' clause in the query to only get the rows you need. Tom Copeland gives a step-by-step 'case study' of analyzing a query in PostgreSQL and how to ensure that your SQL rewrite is actually paying off. programming > sql postasaurus Tue, 12 Dec 2006 10:12:10 GMT