Developer forum

Hi Adrian

What times out? The SQL-server, the IIS or Lucene?

It returns a red message when I try to Build the index. Not sure which one of the three is the cause.

Thanks,

Adrian

And waht does that message say?

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

After this, I cannot try and run it again because the index gets locked

Lock obtain timed out: NativeFSLock@C:\Domains\Sites\floydpepper.dw-demo.com\Files\System\Indexes\ProductswSerialNumbers\ProductswSerialNumbers\A\write.lock

I will try first to optimize my SQL statement and maybe add some indexes on the large table.

Thanks,

Adrian

That is a SQL-server timeout - so you need to find a way to make the SQL faster. It is indexing using a reader, so it should be possible to go through all records. But it is a BIG job indexing 9 mio records, so you need to make sure you have the right server setup so SQL + IIS has enough memory and does not restart in the middle of the process.

Understood. 

I have tried indexing just the big table, without any joins and it runs ok in about 3 minutes for 9 milion records.

I am not sure if I can expect it to run in 53 minutes on the final 160 milion rows :)

Thanks,
Adrian