mgm_03 Posted September 8, 2003 Share Posted September 8, 2003 My application will involve potentially hundreds or thousands of companies. On one webpage I want to have alphabetical links that correspond to companies whose name starts with a certain letter. When the user clicks a letter, all the companies in that letter category are returned... (all hyperlinks ->) A B C D E ...X Y Z It seems to me, querying the database on each click might be inefficient if the info is relatively static. Would it make better sense to do the query periodically to keep it up to date? Then store the query results in a text file which is retrieved and ouputted when the user clicks a letter. Quote Link to comment https://forums.phpfreaks.com/topic/996-reducing-load-on-mysql/ Share on other sites More sharing options...
McGruff Posted September 8, 2003 Share Posted September 8, 2003 How much information are you going to be returning on each query? For instance, if someone clicks on the letter A, are they just going to see a list of company names beggining with A, or are they going to see the company name, a paragraph about the company, location of the company, # of employees... If you are just returning a name, or something short, I wouldn\'t bother with the text file. MySQL can return queries like that very fast, even if you have several thousand companies per letter. True, accessing static test files will be faster, but unless you have a ton of info per company, in my opinion, it isn\'t worth the extra effort on your part. Quote Link to comment https://forums.phpfreaks.com/topic/996-reducing-load-on-mysql/#findComment-3376 Share on other sites More sharing options...
mgm_03 Posted September 9, 2003 Author Share Posted September 9, 2003 Thanks for replying. Just retrieving: Company, address, city, state, area code, phone I\'m thinking there probably won\'t be more than a few hundred companies whose names all start with the same letter so...probably database is the way to go. Quote Link to comment https://forums.phpfreaks.com/topic/996-reducing-load-on-mysql/#findComment-3379 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.