Query Performance

Using the NorthwindIB database, I inserted 50k records in Order Table.

When I used the native SQL Adapter, it only took me a second to fetch the data.

But when I execute this query using Devforce:

 

          NorthwindIBEntities _context = new NorthwindIBEntities();

  var orderquery = _context.Orders.Select(p => p).OrderBy(p => p.OrderID).Skip(0).Take(50000);

           _context.ExecuteQueryAsync(orderquery, p =>

            {

                if (!p.HasError)

                {

                    // My code here..

                }

            }, null);

It took me 30 seconds to finish the async query..

Why is this so? Am I missing some configuration or performance tips?

Another, when I use the SQL Profiler to get the SQL query provided by Entity Framework and execute it in the Management Studio, it also took me a second to finish it.

Your help is highly appreciated. :)

Thanks,

Von 

 

When you tested using DevForce, were you doing in 2-tier or n-tier?

 

Silvio.

Entity Framework is slightly faster than DevForce considering DevForce has some overhead over EF and is optmized for n-tier.

 

A few suggestions:

 

1) Try turning Query Inversion off:

 

You can find more information about query inversion in the DevForce Resource Center.

 

2) You could also try querying a reasonable number the entities, i.e. 50, after async querying for everything

3) As a last resource, you could always user SqlDataReader to populate a POCO. You can store POCOs in the EntityManager's cache and query them. You can find additional information about POCOs in our DevForce Resource Center. There is nothing wrong with falling back to SqlDataReader occasionally, using it in a few places for hot spot performance improvements.

 

Silvio.