|
I realize that I don’t need that
many rows. I want to narrow down the rows I query to
ONLY the ones for the current order. I thought I was doing this by setting the
relationship between the two tables, but no. The question is how do I go about getting
only these rows. Do I have to do a parameterized query and fill in the
value in an on data change event? Rick From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of paul.mercea 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 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
