Jet Engine And Data Retrieval From Tables

[dominicdunmow]

Hi there,

I've put together a database and to keep things 'looking' neat and tidy I've stored all the static data to one table, so there are about 10 fields in the table all completely independent of one another.

Will this method hamper the performance of the database when the comboboxes on my form try to retrieve their respective data?

E.g. I have a combobox on a form for Customer name. The comboxo gets the list og customer names via a query from the table. Does the Jet Engine retrieve all the fields in the table and then single out and return only the Customer field? or from the off does it just look for the Customer field?

And hence would it be more efficient if I hade a separate table for the customer name and for each other field that is used by a combobox?

Thanks

 

[r937]

if the 10 fields are independent, and one of them is customer name, i'm curious what the rows look like that have customer names in them -- what values could possibly be in the other fields? won't the values be duplicated?

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts March 6 2005)

 

[dominicdunmow]

The fields contain data such as Region, Sales Region, Start Date etc.

The way I use the table is as a source for the comboboxes on my form.

So in the Customer dropdown the query asks for only the customer field. The control field is on another table.

In the start date, the combobox asks only for the available dates then returns the selected value to another table.

The functionality works, it jsut I am trying to improve the perfomrance of the database and I wondered whether it is more efficient to store independent data in separate tables rather than one - I guess it depends how jet queries the table.

It is this I am looking to find out.