Skip to main content.
home | support | download

Back to List Archive

Re: Using Swish-e search capabilities within ASP

From: CheHax <chehax(at)>
Date: Thu Mar 31 2005 - 08:27:25 GMT
Hello Bill, thank you for you fast reply.

As I read your answer, I am quite confused about the fact that Swish-e
is not the good solution since I have 25 million records. If swish-e
is not that best solution, what would be the best one then ? Fulltext
search in mySQL is not an option, and I'm afraid I'll soon have to
handle even more records than the current 25M ones.

Records in my table can be filtered by regional code, and I suggested
we could split the table into several smaller ones, but this solution
wasn't accepted. What do you think of it ?

As of the DLL, I'm gonna try to embed it into a home made activeX
then. I think this could do the trick.


On Mar 30, 2005 8:16 PM, Bill Moseley <> wrote:
> On Wed, Mar 30, 2005 at 08:26:14AM -0800, CheHax wrote:
> > I am a new Swish-e user and kind of an addict as well since I tried it
> > on my 25M records database, and if I have yet to work on the indexing
> > phase, I'm wondering how I can use my index file from ASP pages.
> 25 *million* records?  My guess is swish won't be your best solution.
> > The fact is that my whole website runs under IIS, in ASP pages using
> > VBScript. My guess is that an ActiveX would be the key, but there does
> > not seem to be any to use Swish-e, or at least not a recent and
> > suitable one for heavy loaded server.
> Sorry, can't offer any help with those technologies -- they are all
> foreign to me.  Swish has a dll for windows, so I'd expect there would
> be a way to link with that.
> > Yet, it may be possible to call the cgi app from an ASP page, but I
> > have no clue how to do that and wouldn't mind a bit of help. Unless
> > you tell me it will be way to slow for like 10000 request an hour.
> I wouldn't run it as a CGI application.  10,000 searches per hour?
> 10,000 static pages perl hour?  What's that about 3 requests per
> second?  That doesn't sound too hard to manage -- depending on your
> hardware.
> --
> Bill Moseley
> Unsubscribe from or help with the swish-e list:
> Help with Swish-e:
Received on Thu Mar 31 00:27:34 2005