|
First off all....you don't need 1 mill records...try to get
olny 100-1000 records.
Users don't need 1 mil records to view!
Regards From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rick Roen Sent: Friday, October 13, 2006 5:04 PM To: [email protected] Subject: [Firebird-net-provider] slow connection VS.Net 2005 + Firebird
1.5 I’m just learning VB.net and playing
with data connection. I have a FB database with typical
customer->orders->orderitems relationships I am doing a test Windows form to
display the customer and tables for their orders and
orderitems. I have the relationships set between
the tables and the controls display the correct information, however VERY
slowly. The form takes several minutes to open and is several seconds to
change customers. I do a TableAdapter.Fill for each of
the tables on the onLoad event of the form. This seems to load ALL of the
rows of each table since when I comment out the largest table (orderitems = 1+
million rows) the load time becomes much quicker. I want to return only the relevant
rows for the customer in orders and orderitems, but I think I am getting them
all. How do I set this up correctly? Rick |
------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
