Re: Implementation of full text

From: Hilary Cotter (hilary.cotter_at_gmail.com)
Date: 09/28/04

  • Next message: Anil Saharan: "Re: Implementation of full text" 
    Date: Tue, 28 Sep 2004 13:53:18 -0400

    Duh, sorry about that I missed your question entirely. I wrote an extended
    proc to filter out noise words. It seems to me that there was a much greater
    limit than 256 bytes for a single parameter.

    I'm don't know enough about the internals of MSSearch to answer your
    questions. Here are some general observations.

    There is no documented way of accessing the MSSearch catalogs directly other
    than through SQL Server. The results set handed back to SQL from MSSearch
    consists of a key value and a rank. You then have to join this against the
    tables in SQL Server to identify the row the hit occurs in.

    SQL Server uses a named pipe to connect to MSSeach with and to retrieve the
    results.'

    Did you consult Using xp_gettable_odbc in BOL for an example of returning a
    table to a client from an extended stored procedure. 

    -- 
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Anil Saharan" <aksaharan@devdex.com> wrote in message
news:uqDJKEYpEHA.1296@TK2MSFTNGP12.phx.gbl...
> Actually the question I framed was a bit irrelevant to what I am looking
> for.
>
> The actual problems are related to the Extended Stored Procedures
> implementation for,
>  1. To take input of more that 256 characters data or a recordset
> (current system limit being 256 characters).
>  2. To use the recordset returned from the ESP as a virtual table
> (within a function the recordset returned in invalidated, it is valid
> only in the procedures).
>
> These are the two things which would be used even in FTS module also,
> and was wondering how is this implemeted in it.
>
> Probably FTS uses shared memory to implement it internally.
>
> Is there a way out of those two limitations to pass recordset/huge data
> as input and use retuned recordset as virtual table?
>
> Thanks,
> ---
> Anil Saharan
> http://www.aksaharan.com
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
>
  • Next message: Anil Saharan: "Re: Implementation of full text"

    Relevant Pages

    • Re: Extended Stored Procedure: Loopback connection
      ... SQL Server ships a sample exactly showing this: ... SQLRETURN sret, ... SRV_PROC* srvproc); ... NULL, 0, 0, "Error executing extended stored procedure: ...
      (microsoft.public.sqlserver.odbc)
    • Re: Cross Database Join, C++ program set up confusion
      ... Well what kind of data are you returning if it is not in Recordset? ... Recordset is returned (it is fractionally faster as ADO does not waste time ... If the default database is db1 on the ... It is a function of SQL Server. ...
      (microsoft.public.vc.database)
    • Re: Full-Text Results to MS Access
      ... Being new to SQL Server and ADO, ... (My database was started in pre-ADO days so the Access ... like a true/false flag, a value, etc., but if the result is a recordset, I ... based on some full-text search criteria. ...
      (microsoft.public.sqlserver.fulltext)
    • Re: type argument in OpenRecordset method
      ... For efficiency reasons you should always open the least-functional recordset ... Since you are using SQL Server linked tables, you have a choice of three: ... dbOpenSnapshot: recordset can't be updated, but you can navigate in it. ... Dim strExec As String ...
      (comp.databases.ms-access)
    • Subform loses recordset - shows #Name?
      ... Data is pulled from the SQL Server ... additional sproc for each subform. ... ADODB.Recordset is then applied to each of the forms/subforms Recordset ... Dim rstUsers As ADODB.Recordset: ...
      (comp.databases.ms-access)