Author: Andrei Fortuna
Date: 15:42:31 06/11/02
Go up one level in this thread
varchar(2000) : you have messages that are 65000+ chars, for example some of Dann's posts ... as I said in another post I am not sure it's doable ... having indexed text searches etc ... but I will try it anyway since it would simplify my job anyway as for the existing engine : you're welcome :) On June 11, 2002 at 17:42:56, José Carlos wrote: >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.