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. Link to comment https://forums.phpfreaks.com/topic/114678-how-would-you-put-a-word-list-into-a-database/ 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... Link to comment https://forums.phpfreaks.com/topic/114678-how-would-you-put-a-word-list-into-a-database/#findComment-589776 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.