Hello:
>
> 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.
>
If you are using a SELECT * FROM TABLE_NAME that is what is should be
doing
you will need to parametrize the query
> Subject: [Firebird-net-provider] slow connection
> 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.
>
>
iders'
Subject: Re:
[Firebird-net-provider] slow connection
First off allyou 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
t-provider@lists.sourceforge.netSubject:
[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 custome
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 re
