Slow Query Log Entries

Print Thread

Hop To

Re: Slow Query Log Entries BellaOnline #175652 01/26/2007 12:35 PM
Joined: Jun 2006 Posts: 693 BellaOnline Addict
BellaOnline Addict Joined: Jun 2006 Posts: 693	I.e. it seems the user is probably searching "all public forums". Can't you just do the query for form type = public, vs having to enumerate every single ID? String-matching text queries are slow enough to start with ... Lisa Shea, owner, BellaOnline.com BellaOnline Website BellaOnline Forums - UBB since Apr 2002 - 58,000 members / 850,000 posts

Link Copied to Clipboard

Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.

UBB.threads PHP Forum Software Community Forums UBB.threads Version 7/8 Support Slow Query Log Entries