Re: [Firebird-net-provider] Creating an Entity Data Model is very slow with many Tables

[Reinhard G. <R.G...@bs...>]

If someone has the same problem: 
I found a solution that works for me.

The Firebird .NET Provider Source contains 16 selects to the system tables.
I created tables for the resultset of each select  and a stored procedure that fills these tables.
Then I replaced the selects in the providers source code to select from these tables instead from the system tables and compiled it.

Result: 1 Min 20 Sec instead of 8+ Min for updating the Entity Model.

Greetings Reinhard

-----Ursprüngliche Nachricht-----
Von: Jiri Cincura [mailto:di...@ci...] 
Gesendet: Mittwoch, 13. Februar 2013 17:22


On Wed, Feb 13, 2013 at 4:19 PM, Reinhard Gunacker <R.G...@bs...> wrote:
> The point is, that I selected only one single Table but it is slow anyhow!

Yes, the query is same. Only amount of data transfered is not that huge. If you're on a fast line that will not make a difference.

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

------------------------------------------------------------------------------
Free Next-Gen Firewall Hardware Offer
Buy your Sophos next-gen firewall before the end March 2013 and get the hardware for free! Learn more.
http://p.sf.net/sfu/sophos-d2d-feb
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider