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:disk...@cincura.net] Gesendet: Mittwoch, 13. Februar 2013 17:22 On Wed, Feb 13, 2013 at 4:19 PM, Reinhard Gunacker <r.gunac...@bsf.at> 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------------------------------------------------------ Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_feb _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
