https://bugzilla.novell.com/show_bug.cgi?id=699643
https://bugzilla.novell.com/show_bug.cgi?id=699643#c2 --- Comment #2 from scott fluto <srfcan...@hotmail.com> 2011-06-15 21:42:12 UTC --- looking at the performance issue around how it generates the parameter information, if you do the following: modify TdsMetaParameter.cs: line 249: from: int paramSize = GetActualSize () / 2; to: int paramSize = Size < 1 ? GetActualSize () / 2 : Size; and line 221: from: typeName = "image"; to: typeName = "varbinary(max)"; doing this will cause the parameter information to generate the same TDS parameter data the same as windows does and will generate the same TDS Parameter data for the same sql command which should improve the query performance since sqlserver will be able to look up the query in its cache rather than have to parse it every time. Note that the change to line 221 may be an issue for older versions of sqlserver that dont use varbinary(max) but keeping it as Image should still be ok since it will still generate the same sql command. Ill rerun our performance tests to see if I see and differences in performance. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug. You are the assignee for the bug. _______________________________________________ mono-bugs maillist - mono-bugs@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-bugs
