Part of the EllisLab Network
pMachine Pro has been replaced by ExpressionEngine, our full featured web publishing solution. Please consider upgrading.
You can download pMachine Pro here: Download pMachine Pro  |  Download Language Packs
   
 
Speed question
Posted: 15 November 2004 04:44 PM   [ Ignore ]  
Lab Assistant
Avatar
RankRank
Total Posts:  194
Joined  2003-10-12

Hi

I’m building a site that will have a large number of small entries. What’s the most speedy way to allow visitors to find the content they want?

- create a large number of categories (several dozen) and let the user sort entries based on the category. (in this case it will be a city name)

- put the city name in the title field and let users search for a city name based on this title field.

The bottom line, I guess, is that I’m asking what’s faster from a database point-of-view, sorting categories or searching fields, or art they the same thing?

Thanks!

 Signature 

Peter Dinesen
Dinesen-Schacht
http://iSawYou.com

Profile
 
 
Posted: 16 November 2004 01:49 AM   [ Ignore ]   [ # 1 ]  
Administrator
Avatar
RankRankRankRankRank
Total Posts:  2541
Joined  2001-12-21

If you are using the search module it won’t make any difference since the tables are joined during the process.

 Signature 
Profile
 
 
Posted: 16 November 2004 10:26 AM   [ Ignore ]   [ # 2 ]  
Lab Assistant
Avatar
RankRank
Total Posts:  194
Joined  2003-10-12

Thanks Rick.

 Signature 

Peter Dinesen
Dinesen-Schacht
http://iSawYou.com

Profile
 
 
   
 
 
Post Marker Legend
New Topic New posts Hot Topic Hot Topic with new posts New Poll New Poll Moved Topic Moved Topic Sticky Topic Sticky topic
Old Topic No new posts Hot Old Topic Hot Topic with no new posts Old Poll Old Poll Closed Topic Closed Topic Announcement Announcements
Theme
Change Theme
Visitor Statistics
The most visitors ever was 233, on December 18, 2007 12:04 AM
Total Registered Members: 64967 Total Logged-in Users: 0
Total Topics: 81989 Total Anonymous Users: 0
Total Replies: 440669 Total Guests: 17
Total Posts: 522658    
Members ( View Memberlist )
Active Members: