Did you try to compare the speed of PHP and C front-ends?
Brandon LaBonte wrote:
>
> I probably should have also noted that I am using the PHP front end...
>
> Thanks,
>
> Brandon
>
> -----Original Message-----
> From: Alexander Barkov [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 24, 2000 2:05 AM
> To: Brandon LaBonte
> Cc: '[EMAIL PROTECTED]'
> Subject: Re: UdmSearch: Speed Issues with Oracle
>
> Hello!
>
> Try the following.
>
> Add "#define DEBUG_SQL 1" in the top of sql.c
> Recompile
> Run search from command line and check stderr output:
>
> search.cgi "words to find" >/dev/null
>
> Brandon LaBonte wrote:
> >
> >
> > Hello,
> >
> > I am using UDMsearch with an Oracle Server. The Oracle server is pretty
> > well set up, and has good hardware (733Mhz, 512MB Ram, 27GB storage).
> >
> > I have notices that when I search for more than one word, the response
> seems
> > much slower. Each additional word seems to slow the server down at an
> > exponential rate. Is this a fault of the way the SQL statement is set up?
> >
> > Anyone seen this problem, and more importantly, has anyone discovered a
> fix?
> >
> > Thanks,
> >
> > Brandon
______________
If you want to unsubscribe send "unsubscribe udmsearch"
to [EMAIL PROTECTED]