URGENT : removing unnecessary CAST in generated queries
URGENT : removing unnecessary CAST in generated queries
Hi,
I would like to know how can I ensure that SQL statements being generated by dotConnect for mysql will be without unnecessary CAST?
Its causing major performance hit on our DB.
I am using 6230 version
e.g.
AND (((cast(Extent1.created_date as datetime)) >= '2011-11-16T00:00:00.00' /* @p__linq__0 */)
AND ((cast(Extent1.created_date as datetime)) < '2011-11-17T00:00:00.00' /* @p__linq__1 */)))
Thanks
I would like to know how can I ensure that SQL statements being generated by dotConnect for mysql will be without unnecessary CAST?
Its causing major performance hit on our DB.
I am using 6230 version
e.g.
AND (((cast(Extent1.created_date as datetime)) >= '2011-11-16T00:00:00.00' /* @p__linq__0 */)
AND ((cast(Extent1.created_date as datetime)) < '2011-11-17T00:00:00.00' /* @p__linq__1 */)))
Thanks
Its a big project and to break it to small pieces will take some time.
Just create any model with Mysql DataTime datatype in the DB and DateTime in c# and compare between dates and the result is CAST from string to DateTime in the generated query.
I tried with LINQ pad mysql driver which doesnt generate sql statements with CAST
Just create any model with Mysql DataTime datatype in the DB and DateTime in c# and compare between dates and the result is CAST from string to DateTime in the generated query.
I tried with LINQ pad mysql driver which doesnt generate sql statements with CAST
We are investigating the issue.yhersh wrote:This is a major bug which must be fixed ASAP and the support is very slow....we have a live production site which is suffering performance due to this issue.
Our support has a two business day response policy: http://www.devart.com/dotconnect/mysql/ ... pport.html.yhersh wrote:Is this your normal response time ?