how to manage linked table with delphi / ado ?

From: Cengis (cengis.kocaurlu_at_prodiag.fr)
Date: 08/30/04 

Date: Mon, 30 Aug 2004 12:11:24 +0200

hello,

i'm currently writing an internal software to manage informations about
yours clients like computers / softwares installed, updates planning etc ...

all client informations are linked from another database (from the
software we use for billing etc ...: multidevis) in the access database

clients.mdb mydatabase.mdb
|- clients table ----------> |- clients table link
|... |- clients_softwares
                                |- ...

but linked table are slow and it take 1sec to get results in every query
that involve the linked table, so i need some advices on the best way to
improve the query speed

note: in my querys i use the linked table
exemple
query mydatabase.mdb
'select * from clients_softwares right join clients on ...'

note: i just need to read the client table no update from my
application, updates are made from multidevis)

thx
Cengis.

Quantcast