Complex queries in LSCS ?

Andy Knipp

OK, running some benchmarks with complex queries. Playing with the query to improve as I can.

Thing is, I am getting it down to 100ms per complex query (querying multiple EAs - within a Date range, and specific model)


That seems to be pretty slow.


Queries for specific DCR values are 4-5 msec.


Am I jaded ? Does this seem reasonable ?

Funny thing, we have tried it on a few different servers, one is a super beefy Solaris server with 32GB of RAM and 8 multi-threaded CPUs.

It seems to be spending a ton of time querying the DB.

Any tips/pointers/RTFMs appreciated.