[Mono-bugs] [Bug 699643] saving a DBNull field saves as and empty string in the sqlserver database

[bugzilla_noreply at novell.com]

https://bugzilla.novell.com/show_bug.cgi?id=699643

https://bugzilla.novell.com/show_bug.cgi?id=699643#c2


--- Comment #2 from scott fluto <srfcanada at 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.