|
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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
