Best approach for high volume searches?
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=18464
Printed Date: 29 March 2026 at 4:24pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Best approach for high volume searches?
Posted By: MadDog
Subject: Best approach for high volume searches?
Date Posted: 21 February 2006 at 4:28am
|
What is the best approach for dealing with a high amount of people searching with a very large database? ------------- http://www.iportalx.net" rel="nofollow"> 
|
Replies:
Posted By: The WizeGuy
Date Posted: 18 March 2006 at 12:09pm
|
what dbms do You have in mind?
But, generally a fulltext-index speeds things up ..... only one disadvantage. The size of the index.....will end up to about the same size as the whole table
cya, /PB ------------- -- second place is the first looser -- |
Posted By: michael
Date Posted: 18 March 2006 at 2:39pm
|
If FT Index is not an option it makes quite a difference how you index you tables in general. You can also create archive tables with posts older than x weeks, searching only the new ones initially and give the option to search old ones later... ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |