Re: Help on performance question

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi,

no I do net get the whole records in asingler queery becasue as the remote
databased is distributing data to soem other local application, I do not waht
to get some locking trouble and as you know that it is access DB I do not
want to cause any risk.

Fro that reason I take in a first querry concerned data for TAble A (100)
records and store then in a TableADataset

Then I scan row by row this dataset and retrive other corresponding data
from the remote DB in a second dataset. (this the place wher it could take
time)

Indexes in the remote table, they are sure, but I am not the owner of that
database and cannot change any structure. I just have the right to extract
data

I have been told that retriveind requested data in an SQL querry is faster
that retriving locally each Table content in dataset and define relation
between those tables

what do you think

regards
serge

"Robbe Morris [C# MVP]" wrote:

> Do you really need to bring all 1000 back in a single query?
>
> That is a lot to hold in memory. Are the columns in
> your WHERE clause for table B indexed properly?
>
> --
> 2004 and 2005 Microsoft MVP C#
> Robbe Morris
> http://www.masterado.net
>
> Earn $$$ money answering .NET Framework
> messageboard posts at EggHeadCafe.com.
> http://www.eggheadcafe.com/forums/merit.asp
>
>
>
> "serge calderara" <sergecalderara@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
> message news:14EE16EA-30AE-4757-AA4D-9EF1C9BD1CE2@xxxxxxxxxxxxxxxx
> > Dear all,
> >
> > I have a windows application which is able to collect particular data on a
> > remote Access database that can be in use by other local application
> > I cannot change the structure of that remote database.
> >
> > From my application i collect data between 3 different linked tables.
> > The way I am collecting data, I am collecting first, records from table A
> > ans store them in a dataset named DatasetA
> >
> > Then from that DataSetA I scan each unique records and retrive
> > corresponding
> > entry from the remote database through the same connection .
> >
> > What I have noticed is that, it takes quite long time in my mind to
> > retrive
> > data especially if DataSetA records get many entries in other tables
> >
> > For example:
> > If in DataSetA i have 100 rows and for each rows I have 10 records in
> > other
> > tables, which means 1000 records, it takes around 2minutes.
> >
> > I was wondering if I am cllecting data in the proper way or is they a way
> > to
> > speedup that row scan ?
> >
> > thanks for wyour reply
> > regards
> > serge
>
>
>
.

Relevant Pages

  • Challenging ADO.NET situation (long)
    ... need to import those records into the local database. ... depending on a "type" column in the master (ie some records ... independantly, but data is always transfered from remote to local, not the ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Challenging ADO.NET situation (long)
    ... need to import those records into the local database. ... depending on a "type" column in the master (ie some records ... independantly, but data is always transfered from remote to local, not the ...
    (microsoft.public.dotnet.framework.adonet)
  • A Way Forward?
    ... Lets say that the remote databases have an autonumber for the local computer ... reference ID in the Procurement and Purchase Order table AND another column ... but this database design seems to be a very complex problem. ... Setting incremental numbering based on Australian FY set ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Please help with remote access to FM Pro Server 7
    ... But if it is to access a database from a remote location, ... - both local and remote computers are simply connected to internet. ... on the local network. ...
    (comp.databases.filemaker)
  • Re: Remote View in VFP 9.0
    ... Is there any other methods to do that without using the remote views. ... If this is a VFP database, SQLCOnnectand SQLExecare not needed at all ... I want to copy the values of a record from table1 to table2 using Remote ...
    (microsoft.public.fox.programmer.exchange)