Tagged Questions
4
votes
3answers
807 views
Is the ADO.NET Entity Framework known for generating poorly performing queries?
This question is inspired by the comment posted to the latest ServerFault blog post:
Are you guys still using LINQ to SQL?
I know I can use SQL Server Profiler and/or the ToTraceString method to ...
5
votes
3answers
2k views
Why does this Entity Framework query perform so bad in MySQL?
Let me give you a little setup. We have a InnoDB table on MySQL 5.1 with close to 20 million records, no foreign keys, and proper indexes for queries we do. We are using the latest 6.3.5 MySQL ...
11
votes
4answers
587 views
When using an ORM, what are some things to watch out for in your database design
What are some database design gotchas to watch out for when you know the database will be accessed using a ORM?
As an example, I'll note the 2100 parameter limit on SqlServer's RPC call. This is a ...
