Anyone any explanation?
Thanks
Otto
The connection URL looks like
"jdbc:microsoft:sqlserver://Formelmonum:1433;SelectMethod=cursor".
SelectMethod cursor proved to be necessary because of other driver related
problems. The question is how it can be that a query like
SELECT weight,field_2,caseid FROM omegauser148_SAMPLES
takes about 2 seconds, while it takes about 45 minutes to do
SELECT weight,field_2, smptbl.caseid FROM omegauser148_SAMPLES AS
smptbl, omegauser148_DATASETS AS dstbl WHERE dstbl.datasetid = 56 AND
dstbl.caseid = smptbl.caseid
and this only for the MS JDBC driver. When using J-SQL (NetDirect) for
example, there is no significant difference in speed.
"Otto Perdeck" <otto.p...@xs4all.nl> wrote in message
news:faed9b3c.03111...@posting.google.com...
Thanks.
Sue Purkis
DataDirect Technologies
sue.purkisatdatadirect.com
Please replace the "at" above with @ to reach me by email.
"Otto Perdeck" <Otto.P...@xs4all.nl> wrote in message news:<DeHub.201755$di.45...@amsnews02.chello.com>...
Try this:
props.put("sendStringParametersAsUnicode, "false");
on the connection object before hitting your query?
The "nvarchar-unicode-table scan" problems is usually the case for strangely
poor performance. [Joe Weinstein educated me on this one! :) ]