Computer Chess Club Archives


Search

Terms

Messages

Subject: Re: Slightly OT programming question : searching a word/an expression

Author: José Carlos

Date: 14:42:56 06/11/02

Go up one level in this thread


On June 11, 2002 at 17:35:02, Andrei Fortuna wrote:

>Trust me, I have thought about this.
>I have only one fear - that it would take a tremendous amount of space to store
>word lists :(((((((((

  I don't know what you mean. Why not simple store each post in a row where the
body of the post is just a varchar(2000) or something. Varchar only uses the
space it really needs.
  BTW, thanks for the search engine.

  José C.

>Simple calculus : for each word I have to store the articles it appers into. I
>don't know how efficient sql stores the integers, i.e. how much overhead.
>
>I will have to do some tests though and if the space needed is acceptable then
>you bet I will use only 100% sql and php :))
>
>
>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.