firstly, I submit the query like "select * from [tablename]". And in this table, there are around 30th columns and 40,000 rows data. And I use the standrandAnalyzer to generate the index. And as my experience, it cost 200M disk to store the index.
for example, I will search the "Name" field in the index and it does work perfectly. But when I create an index on the 100,000,000 data. It will cost too much time to index creation. So is there some good solution to solve this? thanks On Jan 15, 2008 10:47 PM, Erick Erickson <[EMAIL PROTECTED]> wrote: > You really have to tell us more about what you're trying to do > to get a meaningful reply. > > What do you mean you create the index on a table? Are you > using some sort of embedded SQL to query the table then > creat a lucene index? How big is the index? What search > are you submitting? What does your search code look like? > > Best > Erick > > On Jan 14, 2008 10:47 PM, coolgeng coolgeng <[EMAIL PROTECTED]> wrote: > > > Hi guys, > > Some problems confuse me. When I would like to index some data from > a > > table in database. While I create the index on this table, the > searching > > job keeps going . How can I work out it? > > By the way, the number of data is around 1 hundred million. > > > > -- > > Best Regards > > Cooper Geng > > > -- Best Regards Cooper Geng