tomdelonge Posted July 14, 2008 Share Posted July 14, 2008 I've got a word list that is not alphabetized (yet). What do you recommend? Should I put the words into tables by letter (say, table "A" has all words that start with "a".) Or will having all words in the same table be just as fast? I'm going to write a little php script to put the words into a database. Would it be better to have them alphabetized before putting them into the database? (I'm talking speed wise). On my website, if a user selects "b" from the menu, then all words that start with b will come up alphabetized. Of course this will be complete with pagination (I have about 60,000 words). Also, I'm not set on a wordlist. If anyone knows of a larger dictionary like one, let me know. I searched for about an hour and couldn't find any large ones in an open format (one I can use, rather than an application using). So, basically, give me your ideas on how I should organize it; For the best processing speeds and such. Quote Link to comment Share on other sites More sharing options...
fenway Posted July 14, 2008 Share Posted July 14, 2008 60K records can easily be housed in a single table... Quote Link to comment 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.