Jump to content

Archived

This topic is now archived and is closed to further replies.

mgm_03

Reducing load on MySQL

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.