Re:Results of BETWEEN
In this case, the problem is not likely to be "locating the job-sheets
that have RECALL like 'Y'." A simple index will find those instantly.
The problem is likely to be "special_inst(blob)." Many query processors
have a lot of problems with blobs and send too much information down the
wire. Try omitting special_inst from the query and see how the query
improves.
Quote
> "Philip L Jackson" <phi...@pcdata.co.uk> wrote:
> > I performn an SQL Query
> > select contract, jobno,recall, special_inst //
> > contract(String9), jobno(integer0), recall(string1),special_inst(blob)
> > from jobsheet
> > where recall like Y
> > If this is run on the server then the result takes a few seconds.
> > If this is run on a workstation, over a 10Tbase network, the query takes 1
> > min 10 seconds.
------------------------------------------------------------------
Sundial Services :: Scottsdale, AZ (USA) :: (480) 946-8259
mailto:i...@sundialservices.com (PGP public key available.)
Quote
> Fast(!), automatic table-repair with two clicks of the mouse!
> ChimneySweep(R): "Click click, it's fixed!" {tm}
> http://www.sundialservices.com/products/chimneysweep