I do not know what you use to "process a request from the app server"?
1. Do you have Long String support turned on in, System > Configuration > Memory and Startup?
2. If you are using webservices you can modify the generated classes and change payload to type %GlobalCharacterStream
The query plan is the same in this instance, however the relative cost is vastly different.
Without TOP 1 = 72497300 (which should give you some idea of the table size)
With TOP 1 = 11
How do you parse the parameters in option 2?
Log in or create a new account to continue