Jump to content


Photo

Reducing load on MySQL


  • Please log in to reply
2 replies to this topic

#1 mgm_03

mgm_03
  • Members
  • PipPipPip
  • Advanced Member
  • 49 posts
  • LocationFort Worth, TX

Posted 08 September 2003 - 06:46 PM

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.
Guru?...in my dreams!
Sorry Everybody

----------------------

#2 McGruff

McGruff
  • Members
  • Pip
  • Newbie
  • 5 posts

Posted 08 September 2003 - 10:54 PM

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.
McGruff [br] [br]\"I\'m working so I won\'t have to try so hard\" [br]- The Strokes

#3 mgm_03

mgm_03
  • Members
  • PipPipPip
  • Advanced Member
  • 49 posts
  • LocationFort Worth, TX

Posted 09 September 2003 - 03:12 AM

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.
Guru?...in my dreams!
Sorry Everybody

----------------------




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users