Hi, Madhu Sasidhar, MD schrieb: > Mathias, Please check your query syntax and Db (indexes and keys). > Even the most complex JOINS with > 10000 records returned in my > VB.NET does not take more than a few milliseconds. > You may have to optimize your Db/SP or query. MS
well, unfortunately I can't seem to find a problem with my query or indexes/keys. Maybe you can see any sense in this and help: Query: ------ SELECT visits.VISITED, visits.BROWSER, SiteUrls.URL, titles.TITLE FROM SiteUrls INNER JOIN (titles INNER JOIN visits ON titles.IDTITLE = visits.TITLEID) ON SiteUrls.idSiteUrl = visits.URLID ORDER BY visits.VISITED DESC; (Using RIGHT JOIN does not make a difference.) On those tables, the timestamp column "visits.VISITED" has a descending index, while titles.IDTITLE and SiteUrls.idSiteUrl are (bigint) primary keys and visits.TitleID and visits.URLID are bigint columns with ascending index sort order. visits.BROWSER, SiteUrls.URL and titles.TITLE are not indexed because no grouping or sorting takes place on this columns. I also rebuild the indexes (deactivate/activate) and updated database statistics at no avail. Did I overlook something? Regards, Mathias Wuehrmann Mit freundlichen Grüßen, Mathias Wührmann FLEXact Informationssysteme -- Bernhardstr. 22 26122 Oldenburg Tel.: 0441 / 98 330 606 Fax : 0441 / 98 330 609 Web : http://www.flexact.de = <font face="arial, helvetica, sans-serif" size="10"> Mit freundlichen Grüßen,<br><br> Mathias Wührmann<br> FLEXact Informationssysteme<br> -- <br> Bernhardstr. 22<br> 26122 Oldenburg<br><br> Tel.: 0441 / 98 330 606<br> Fax : 0441 / 98 330 609<br> Web : http://www.flexact.de<br> </font> ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
