Author: Andrei Fortuna
Date: 15:32:55 06/11/02
Go up one level in this thread
Aha ... yes, I have played with it too. According to my computations it would take 30 GB or more to store the whole text of all the messages. Because of the overhead, etc. If you can tell me how to create the database to keep the messages with minimum overhead (i.e. if I have 500 Mb of text in 200.000 messages I want it to take maximum 800 MB on harddisk not 30 GB) then I'll be eternally in your debt. On June 11, 2002 at 17:35:15, Adam Oellermann wrote: >Another random thought: MySQL (and many other databases, but you can probably >get MySQL most readily) supports full-text indexing and querying, which would >allow for very flexible searching without having to worry about building word >lists. I've played with this a little and would be happy to help if necessary. > >Regards >Adam > >On June 11, 2002 at 17:13:39, Dann Corbit wrote: > >>A notion: >>Put it in a SQL database and let us perform real searches against it. >> >>A simple wrapper could be put overtop for people who do not understand SQL. >> >>So (for instance) a list could say: >>All of the words: [ ] >>And those would be combined with 'AND' >>and a second list could say: >>Any of the words: [ ] >>And those would be combined with 'OR' >> >>There are many times when I know something is in the list and I could find it >>easily if I could form a SQL query against it.
This page took 0 seconds to execute
Last modified: Thu, 15 Apr 21 08:11:13 -0700
Current Computer Chess Club Forums at Talkchess. This site by Sean Mintz.