DB Connection

[cjkadakia <cj...@sonicbids.com>]

I looked at some of the references to see if this has been explained or not,
but I didn't see anything regarding it. I was wondering, quite simply, if
the SQL Server connection from Solr during indexing is kept alive for all
subsequent delta-import requests, or does it reopen the connection each time
and close it after it's finished?

Thanks kindly.
-CJ
Developer
-- 
View this message in context: http://old.nabble.com/DB-Connection-tp27441937p27441937.html
Sent from the Solr - Dev mailing list archive at Nabble.com.

Re: DB Connection

[Shalin Shekhar Mangar <sh...@gmail.com>]

On Thu, Feb 4, 2010 at 8:08 PM, cjkadakia <cj...@sonicbids.com> wrote:

>
> Thanks. Next, can the 10 seconds be re-configured? We may likely want to
> keep
> the connection alive for a few minutes in case another commit is triggered.
> Is there any reason we may not want to consider this option?
>

Commit on Solr or DB? In any case, creating another connection after a few
minutes is not costly, so why complicate the code.

-- 
Regards,
Shalin Shekhar Mangar.

Re: DB Connection

[cjkadakia <cj...@sonicbids.com>]

Thanks. Next, can the 10 seconds be re-configured? We may likely want to keep
the connection alive for a few minutes in case another commit is triggered.
Is there any reason we may not want to consider this option?
-- 
View this message in context: http://old.nabble.com/DB-Connection-tp27441937p27452210.html
Sent from the Solr - Dev mailing list archive at Nabble.com.

Re: DB Connection

[Shalin Shekhar Mangar <sh...@gmail.com>]

On Thu, Feb 4, 2010 at 12:54 AM, cjkadakia <cj...@sonicbids.com> wrote:

>
> I looked at some of the references to see if this has been explained or
> not,
> but I didn't see anything regarding it. I was wondering, quite simply, if
> the SQL Server connection from Solr during indexing is kept alive for all
> subsequent delta-import requests, or does it reopen the connection each
> time
> and close it after it's finished?
>
>
DataImportHandler re-opens connection if it has not been used for the last
10 seconds. Connections are created at the start of an import and closed
once the import finishes or is aborted.

-- 
Regards,
Shalin Shekhar Mangar.