query with alot of tables

T

thread

Hi all,
I have one query consist with alot of table,
this query is very heavy in the matter of activating it.
is there any solution that the query will be lighter?
 
J

Jason Lepack

Maybe yes, Maybe no.

You need to give more information like the design of the required
tables and their relationships, as well as expected output of the
queries. Also, if you're dealing with a lot of data then you will
want to make sure that you have appropriate indexes.

Cheers,
Jason Lepack
 
J

John W. Vinson

Hi all,
I have one query consist with alot of table,
this query is very heavy in the matter of activating it.
is there any solution that the query will be lighter?
Click to expand...

Yes; simplify the query.

For a more detailed answer please post a more detailed question. There is no
way that anybody reading your message could possibly tell what tables are not
needed, or what other simplifications would meet your needs.

John W. Vinson [MVP]
 
T

thread

i have employee data that it is the master table that all the
relations are build on
besides this all the tables are mostly connected to this master table
by employee number
the output is a big table consist of all the data field gathered from
several of tables
for now i'm using make table to this query but i prefer to use it only
as a select query but just if the proccessing time will be faster

John W. Vinson כתב:
 
J

John W. Vinson

for now i'm using make table to this query but i prefer to use it only
as a select query but just if the proccessing time will be faster
Click to expand...

Consider these two scenarios:

1. Create a Select query.
2. Export from that Query.

vs.

1. Create the same Select query.
2. Run it as a MakeTable query; Access will add the new table to the system
tables, create indexes (unless you've turned off autoindexing), write the
records to the new table, update the indexes, record the table statistics in
the system tables.
3. Export from that Table.

Try it. You'll be pleased.

John W. Vinson [MVP]
 
T

thread

Hi
Thank you for your replay,
i already made this make table that it fastering the process but its
blowing the file size
John W. Vinson כתב:
 
J

John W. Vinson

Hi
Thank you for your replay,
i already made this make table that it fastering the process but its
blowing the file size
Click to expand...

That's rather surprising but I guess that there is some overhead in pulling up
the records to export!

To avoid the bloat, consider creating (in code) a new .mdb file, and doing the
maketable into that. Blow away the mdb when you're done with it.

John W. Vinson [MVP]
 
T

thread

WOW,that sounds like an atractive solution,i belive that will realy
solve the problem
can you have some code examples for this?

John W. Vinson כתב:
 
T

thread

WOW,that sounds like an atractive solution,i belive that will realy
solve the problem
can you have some code examples for this?

John W. Vinson כתב:
 
Top