Let us say the Item Table has 10000 records.

The Manual Sql Statement to retrieve records would be
Select * From Item 

In Entity Framework I am using the Objectset.ToList 
It seems like the provider is issuing select statement for each record and
it takes a while (8 min) to retrieve all records
I am also attaching the debug output for your reference.

Please let me know if you need any further info...

-----Original Message-----
From: Jiri Cincura [mailto:disk...@cincura.net] 
Sent: Tuesday, October 04, 2011 8:56 AM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] Entity Framework

On Tue, Oct 4, 2011 at 2:54 PM, Muthu Annamalai <pearlamer...@gmail.com>
wrote:
> My doubt is the ObjectSet.ToList is the way it is supposed to work ? when
we prepare sql statement manually to retrieve records we only write once and
not one for each record. Secondly the problem in using the fast load "From
statement" is it gets back with anonymous type, which is a problem for
updating the records back...

Can you clarify that.

-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

----------------------------------------------------------------------------
--
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
SELECT 
"Extent1"."ID" AS "ID", 
"Extent1"."ITEMID" AS "ITEMID", 
"Extent1"."STYLENAME" AS "STYLENAME", 
"Extent1"."DESCRIPTION" AS "DESCRIPTION", 
"Extent1"."BARCODE" AS "BARCODE", 
"Extent1"."LOOKUP" AS "LOOKUP", 
"Extent1"."LOCATION" AS "LOCATION", 
"Extent1"."VENDORITEMNUMBER" AS "VENDORITEMNUMBER", 
"Extent1"."COST" AS "COST", 
"Extent1"."PRICE" AS "PRICE", 
"Extent1"."STOCK" AS "STOCK", 
"Extent1"."CASEPACK" AS "CASEPACK", 
"Extent1"."REORDERLEVEL" AS "REORDERLEVEL", 
"Extent1"."REORDERQUANTITY" AS "REORDERQUANTITY", 
"Extent1"."AUTOREORDER" AS "AUTOREORDER", 
"Extent1"."SEASONTYPE" AS "SEASONTYPE", 
"Extent1"."DISCOUNTALLOWED" AS "DISCOUNTALLOWED", 
"Extent1"."ISACTIVE" AS "ISACTIVE"
FROM "ITEMSTYLE" AS "Extent1"

SELECT 
"Extent1"."ID" AS "ID", 
"Extent1"."CATEGORYID" AS "CATEGORYID", 
"Extent1"."VENDORID" AS "VENDORID", 
"Extent1"."ITEMNAME" AS "ITEMNAME", 
"Extent1"."TAXABLE" AS "TAXABLE", 
"Extent1"."ITEMTYPE" AS "ITEMTYPE"
FROM "ITEM" AS "Extent1"
WHERE "Extent1"."ID" = @EntityKeyValue1
FirebirdClient: Parameters:
    FirebirdClient: Name:EntityKeyValue1        Type:Integer     Used Value:3
FirebirdClient: Command:
SELECT 
"Extent1"."ID" AS "ID", 
"Extent1"."CATEGORYID" AS "CATEGORYID", 
"Extent1"."VENDORID" AS "VENDORID", 
"Extent1"."ITEMNAME" AS "ITEMNAME", 
"Extent1"."TAXABLE" AS "TAXABLE", 
"Extent1"."ITEMTYPE" AS "ITEMTYPE"
FROM "ITEM" AS "Extent1"
WHERE "Extent1"."ID" = @EntityKeyValue1
FirebirdClient: Parameters:
    FirebirdClient: Name:EntityKeyValue1        Type:Integer     Used Value:1
FirebirdClient: Command:
SELECT 
"Extent1"."ID" AS "ID", 
"Extent1"."CATEGORYID" AS "CATEGORYID", 
"Extent1"."VENDORID" AS "VENDORID", 
"Extent1"."ITEMNAME" AS "ITEMNAME", 
"Extent1"."TAXABLE" AS "TAXABLE", 
"Extent1"."ITEMTYPE" AS "ITEMTYPE"
FROM "ITEM" AS "Extent1"
WHERE "Extent1"."ID" = @EntityKeyValue1
FirebirdClient: Parameters:
    FirebirdClient: Name:EntityKeyValue1        Type:Integer     Used Value:5
FirebirdClient: Command:
SELECT 
"Extent1"."ID" AS "ID", 
"Extent1"."CATEGORYID" AS "CATEGORYID", 
"Extent1"."VENDORID" AS "VENDORID", 
"Extent1"."ITEMNAME" AS "ITEMNAME", 
"Extent1"."TAXABLE" AS "TAXABLE", 
"Extent1"."ITEMTYPE" AS "ITEMTYPE"
FROM "ITEM" AS "Extent1"
WHERE "Extent1"."ID" = @EntityKeyValue1
FirebirdClient: Parameters:
    FirebirdClient: Name:EntityKeyValue1        Type:Integer     Used Value:5068
FirebirdClient: Command:
SELECT 
"Extent1"."ID" AS "ID", 
"Extent1"."CATEGORYID" AS "CATEGORYID", 
"Extent1"."VENDORID" AS "VENDORID", 
"Extent1"."ITEMNAME" AS "ITEMNAME", 
"Extent1"."TAXABLE" AS "TAXABLE", 
"Extent1"."ITEMTYPE" AS "ITEMTYPE"
FROM "ITEM" AS "Extent1"
WHERE "Extent1"."ID" = @EntityKeyValue1
FirebirdClient: Parameters:
    FirebirdClient: Name:EntityKeyValue1        Type:Integer     Used Value:9
FirebirdClient: Command:
SELECT 
"Extent1"."ID" AS "ID", 
"Extent1"."CATEGORYID" AS "CATEGORYID", 
"Extent1"."VENDORID" AS "VENDORID", 
"Extent1"."ITEMNAME" AS "ITEMNAME", 
"Extent1"."TAXABLE" AS "TAXABLE", 
"Extent1"."ITEMTYPE" AS "ITEMTYPE"
FROM "ITEM" AS "Extent1"
WHERE "Extent1"."ID" = @EntityKeyValue1
FirebirdClient: Parameters:
    FirebirdClient: Name:EntityKeyValue1        Type:Integer     Used Value:8
FirebirdClient: Command:
SELECT 
"Extent1"."ID" AS "ID", 
"Extent1"."CATEGORYID" AS "CATEGORYID", 
"Extent1"."VENDORID" AS "VENDORID", 
"Extent1"."ITEMNAME" AS "ITEMNAME", 
"Extent1"."TAXABLE" AS "TAXABLE", 
"Extent1"."ITEMTYPE" AS "ITEMTYPE"
FROM "ITEM" AS "Extent1"
WHERE "Extent1"."ID" = @EntityKeyValue1
FirebirdClient: Parameters:
    FirebirdClient: Name:EntityKeyValue1        Type:Integer     Used Value:10
FirebirdClient: Command:
SELECT 
"Extent1"."ID" AS "ID", 
"Extent1"."CATEGORYID" AS "CATEGORYID", 
"Extent1"."VENDORID" AS "VENDORID", 
"Extent1"."ITEMNAME" AS "ITEMNAME", 
"Extent1"."TAXABLE" AS "TAXABLE", 
"Extent1"."ITEMTYPE" AS "ITEMTYPE"
FROM "ITEM" AS "Extent1"
WHERE "Extent1"."ID" = @EntityKeyValue1
FirebirdClient: Parameters:
    FirebirdClient: Name:EntityKeyValue1        Type:Integer     Used Value:11
FirebirdClient: Command:
SELECT 
"Extent1"."ID" AS "ID", 
"Extent1"."CATEGORYID" AS "CATEGORYID", 
"Extent1"."VENDORID" AS "VENDORID", 
"Extent1"."ITEMNAME" AS "ITEMNAME", 
"Extent1"."TAXABLE" AS "TAXABLE", 
"Extent1"."ITEMTYPE" AS "ITEMTYPE"
FROM "ITEM" AS "Extent1"
WHERE "Extent1"."ID" = @EntityKeyValue1
FirebirdClient: Parameters:
    FirebirdClient: Name:EntityKeyValue1        Type:Integer     Used Value:13
FirebirdClient: Command:
SELECT 
"Extent1"."ID" AS "ID", 
"Extent1"."CATEGORYID" AS "CATEGORYID", 
"Extent1"."VENDORID" AS "VENDORID", 
"Extent1"."ITEMNAME" AS "ITEMNAME", 
"Extent1"."TAXABLE" AS "TAXABLE", 
"Extent1"."ITEMTYPE" AS "ITEMTYPE"
FROM "ITEM" AS "Extent1"
WHERE "Extent1"."ID" = @EntityKeyValue1
FirebirdClient: Parameters:
    FirebirdClient: Name:EntityKeyValue1        Type:Integer     Used Value:12
FirebirdClient: Command:
SELECT 
"Extent1"."ID" AS "ID", 
"Extent1"."CATEGORYID" AS "CATEGORYID", 
"Extent1"."VENDORID" AS "VENDORID", 
"Extent1"."ITEMNAME" AS "ITEMNAME", 
"Extent1"."TAXABLE" AS "TAXABLE", 
"Extent1"."ITEMTYPE" AS "ITEMTYPE"
FROM "ITEM" AS "Extent1"
WHERE "Extent1"."ID" = @EntityKeyValue1
FirebirdClient: Parameters:
    FirebirdClient: Name:EntityKeyValue1        Type:Integer     Used Value:14
FirebirdClient: Command:
SELECT 
"Extent1"."ID" AS "ID", 
"Extent1"."CATEGORYID" AS "CATEGORYID", 
"Extent1"."VENDORID" AS "VENDORID", 
"Extent1"."ITEMNAME" AS "ITEMNAME", 
"Extent1"."TAXABLE" AS "TAXABLE", 
"Extent1"."ITEMTYPE" AS "ITEMTYPE"
FROM "ITEM" AS "Extent1"
WHERE "Extent1"."ID" = @EntityKeyValue1
FirebirdClient: Parameters:
    FirebirdClient: Name:EntityKeyValue1        Type:Integer     Used Value:15
FirebirdClient: Command:
SELECT 
"Extent1"."ID" AS "ID", 
"Extent1"."CATEGORYID" AS "CATEGORYID", 
"Extent1"."VENDORID" AS "VENDORID", 
"Extent1"."ITEMNAME" AS "ITEMNAME", 
"Extent1"."TAXABLE" AS "TAXABLE", 
"Extent1"."ITEMTYPE" AS "ITEMTYPE"
FROM "ITEM" AS "Extent1"
WHERE "Extent1"."ID" = @EntityKeyValue1
FirebirdClient: Parameters:
    FirebirdClient: Name:EntityKeyValue1        Type:Integer     Used Value:18
FirebirdClient: Command:
SELECT 
"Extent1"."ID" AS "ID", 
"Extent1"."CATEGORYID" AS "CATEGORYID", 
"Extent1"."VENDORID" AS "VENDORID", 
"Extent1"."ITEMNAME" AS "ITEMNAME", 
"Extent1"."TAXABLE" AS "TAXABLE", 
"Extent1"."ITEMTYPE" AS "ITEMTYPE"
FROM "ITEM" AS "Extent1"
WHERE "Extent1"."ID" = @EntityKeyValue1
FirebirdClient: Parameters:
    FirebirdClient: Name:EntityKeyValue1        Type:Integer     Used Value:19
FirebirdClient: Command:
SELECT 
"Extent1"."ID" AS "ID", 
"Extent1"."CATEGORYID" AS "CATEGORYID", 
"Extent1"."VENDORID" AS "VENDORID", 
"Extent1"."ITEMNAME" AS "ITEMNAME", 
"Extent1"."TAXABLE" AS "TAXABLE", 
"Extent1"."ITEMTYPE" AS "ITEMTYPE"
FROM "ITEM" AS "Extent1"
WHERE "Extent1"."ID" = @EntityKeyValue1
FirebirdClient: Parameters:
    FirebirdClient: Name:EntityKeyValue1        Type:Integer     Used Value:20
FirebirdClient: Command:
SELECT 
"Extent1"."ID" AS "ID", 
"Extent1"."CATEGORYID" AS "CATEGORYID", 
"Extent1"."VENDORID" AS "VENDORID", 
"Extent1"."ITEMNAME" AS "ITEMNAME", 
"Extent1"."TAXABLE" AS "TAXABLE", 
"Extent1"."ITEMTYPE" AS "ITEMTYPE"
FROM "ITEM" AS "Extent1"
WHERE "Extent1"."ID" = @EntityKeyValue1
FirebirdClient: Parameters:
    FirebirdClient: Name:EntityKeyValue1        Type:Integer     Used Value:21
FirebirdClient: Command:
SELECT 
"Extent1"."ID" AS "ID", 
"Extent1"."CATEGORYID" AS "CATEGORYID", 
"Extent1"."VENDORID" AS "VENDORID", 
"Extent1"."ITEMNAME" AS "ITEMNAME", 
"Extent1"."TAXABLE" AS "TAXABLE", 
"Extent1"."ITEMTYPE" AS "ITEMTYPE"
FROM "ITEM" AS "Extent1"
WHERE "Extent1"."ID" = @EntityKeyValue1
FirebirdClient: Parameters:
    FirebirdClient: Name:EntityKeyValue1        Type:Integer     Used Value:23
FirebirdClient: Command:
SELECT 
"Extent1"."ID" AS "ID", 
"Extent1"."CATEGORYID" AS "CATEGORYID", 
"Extent1"."VENDORID" AS "VENDORID", 
"Extent1"."ITEMNAME" AS "ITEMNAME", 
"Extent1"."TAXABLE" AS "TAXABLE", 
"Extent1"."ITEMTYPE" AS "ITEMTYPE"
FROM "ITEM" AS "Extent1"
WHERE "Extent1"."ID" = @EntityKeyValue1
FirebirdClient: Parameters:
    FirebirdClient: Name:EntityKeyValue1        Type:Integer     Used Value:22
FirebirdClient: Command:
SELECT 
"Extent1"."ID" AS "ID", 
"Extent1"."CATEGORYID" AS "CATEGORYID", 
"Extent1"."VENDORID" AS "VENDORID", 
"Extent1"."ITEMNAME" AS "ITEMNAME", 
"Extent1"."TAXABLE" AS "TAXABLE", 
"Extent1"."ITEMTYPE" AS "ITEMTYPE"
FROM "ITEM" AS "Extent1"
WHERE "Extent1"."ID" = @EntityKeyValue1
FirebirdClient: Parameters:
    FirebirdClient: Name:EntityKeyValue1        Type:Integer     Used Value:25
FirebirdClient: Command:
SELECT 
"Extent1"."ID" AS "ID", 
"Extent1"."CATEGORYID" AS "CATEGORYID", 
"Extent1"."VENDORID" AS "VENDORID", 
"Extent1"."ITEMNAME" AS "ITEMNAME", 
"Extent1"."TAXABLE" AS "TAXABLE", 
"Extent1"."ITEMTYPE" AS "ITEMTYPE"
FROM "ITEM" AS "Extent1"
WHERE "Extent1"."ID" = @EntityKeyValue1
FirebirdClient: Parameters:
    FirebirdClient: Name:EntityKeyValue1        Type:Integer     Used Value:28
FirebirdClient: Command:

FirebirdClient: Parameters:
    FirebirdClient: Name:EntityKeyValue1        Type:Integer     Used Value:274
The program '[852] PearlPOS.vshost.exe: Managed (v4.0.30319)' has exited with 
code 0 (0x0).
------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to