RE: Assistance in calling lucene search from SQL Server 2008

[Paul Irwin <pi...@feature23.com>]

 trigger
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=20cf30780db0a615a304eaf4e59e

--20cf30780db0a615a304eaf4e59e
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

I agree with Anders. Triggers should be as lightweight as possible if
you are going to use them at all. Performing an HTTP or remoting
request is the opposite of minimal.

Can you do it from outside SQL, or at the very least from a stored
proc? See here for discussion:
http://stackoverflow.com/questions/3048340/when-are-database-triggers-bad

Paul Irwin

Sent from my Windows Phone, so please forgive my brevity! From: Anders
Lybecker
Sent: =E2=80=8E11/=E2=80=8E12/=E2=80=8E2013 1:24 AM
To: user@lucenenet.apache.org
Subject: Re: Assistance in calling lucene search from SQL Server 2008
trigger
Hi,

This is not a Lucene.Net issue.
You could make a Web API project and call via SQLCLR WebRequest (
http://blogs.msdn.com/b/sqllive/archive/2008/06/18/accessing-rest-based-web=
-services-using-sql-clr.aspx
).

The architecture you describe is not what I would recommend. If you
requirements are fixed, I would rather create a service endpoint that first
called the SQL Server and then Lucene. It is a much cleaner solution.

Regards,
Anders Lybecker




On Tue, Nov 12, 2013 at 3:44 AM, Jackson <ja...@smartinfotech.ae> wrote=
:

> Dear Developers,
>
> We are new to using Lucene.net. The solution developed required specific
> searching of names from 1000=E2=80=99s of names, which is happening well =
using your
> developed
> Lucene 3.0.3 search engine library. We had tested calling the lucene
> search from a aspx page and were very excited with the speed it was getti=
ng
> the result.
>
> Our requirement is to call the lucene 3.0.3 search from a database trigge=
r
> and we are unable to find a solution. If there is a help / link, that cou=
ld
> be provided
> to know how it could be called from the Sql server 2008 database trigger,
> we would highly appreciate your support.
>
>
> Best Regards,
>
> Jackson Vadakkan
> SMART Infotech
> Post Box 28046, Abu Dhabi,
> United Arab Emirates.
> Phone : +971-2-6438460
> Mobile : +971-50-7724164
>
> DISCLAIMER: This Electronic Mail and any attached information is sent on
> behalf of SMART Infotech. The information is confidential and may also be
> privileged. It is intended only for the use of authorized persons.
> If you are not an addressee, or have received the message in error, you
> are not authorized to read, copy, disseminate, distribute or use the
> Electronic Mail or any attachment in any way.
> Please notify the sender by return E-Mail or over the telephone and delet=
e
> this e-mail.

--20cf30780db0a615a304eaf4e59e--