on 2006 Nov 10 11:12 AM
Maybe, here, someone could help me.
I've been edited a BDoc write on CRM server. this Bdoc is converting to a sql statement executed on local SQL server DB.
The generated query contains OPTION (FAST 100) at the end. In some case this option make the query resultset time very long: a particular execution that return 16 record can from 2 second to 48!!!!!!
how can i disable on the server the insert of this options?
THX
Hey Angelo,
the OPTION (FAST 100) does not necceserly creates the problem,
this might also be due to a missing index,
the fast results can return if the table is already in the buffer,
try to run the same queries twice, usally the first time takes longer
than the second time.
try to create an index on the selected fields.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
67 | |
11 | |
10 | |
10 | |
9 | |
9 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.