HELP DataRelation or SQL join ????

[serge calderara]

Dear all,

I have an access database which is access by an application.
From a remote PC using vb.net I am able to access to this database and
collect necessary data. I need to make the remote connection and data
collection as fast as possible in order to avoid potential locking situation.

The data I am interesting in are located in 3 different tables.

My question is :

Is it better to connect to the database and collect each table data in
separate .NET dataset ( the db connection will be close) and make necessary
datarelation in my VB.NET application ?

or

Is better to connect to the database and run an JOIN SQL statement and
collect all my necessary data in one uinque dataset with all needed
information ?

Please not that this remote database could have more than 4000 records in
tables.
In other words I need to get the connection to the database as short as
possible

thnaks for your comment
regards
serge

[Andrew D. Newbould]

In message <CB**********************************@microsoft.co m>, serge
calderara <se************@discussions.microsoft.com> writes

The data I am interesting in are located in 3 different tables.

My question is :

Is it better to connect to the database and collect each table data in
separate .NET dataset ( the db connection will be close) and make necessary
datarelation in my VB.NET application ?

or

Is better to connect to the database and run an JOIN SQL statement and
collect all my necessary data in one uinque dataset with all needed
information ?

The general rule of thumb would be to use the SQL JOIN method and
therefore the power of the database engine to retrieve the required
records. By doing the job properly and only specifying the required
fields from each table you will always get the data faster
(specifically, you are transferring less data - think about for a
while).

There are not really that many scenarios where you would take your first
idea (ie: you really would be updating the contents of all records in
each table, and then you need to reconnect to send it back).

--
Andrew D. Newbould E-Mail: ne********@NOSPAMzadsoft.com

ZAD Software Systems Web : www.zadsoft.com