If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
???Takes very long to do make table query
Would very much appreciate expert advice on why it takes a minute to run a
select query, but takes forever to do Make table query on the same set -- Thanks a million for your time and expert advice :-) Jaylin *****Jaylin Message ended******* |
#2
|
|||
|
|||
???Takes very long to do make table query
One reason is that SELECT is probably using an index, whilst make table is
probably building one. Another reason is that it takes longer to write records (and read-verify, than it does to just read them. Another reason is that writing records is probably a one at a time function, whilst reading is often done as lock operation. "Jaylin" wrote in message ... Would very much appreciate expert advice on why it takes a minute to run a select query, but takes forever to do Make table query on the same set -- Thanks a million for your time and expert advice :-) Jaylin *****Jaylin Message ended******* |
#3
|
|||
|
|||
???Takes very long to do make table query
Dear Mr Cox
Thank you very much for your wise advice. Just wondering if there is anyway I can make the query run faster? Many thanks again -- Thanks a million for your time and expert advice :-) Jaylin *****Jaylin Message ended******* "David F Cox" wrote: One reason is that SELECT is probably using an index, whilst make table is probably building one. Another reason is that it takes longer to write records (and read-verify, than it does to just read them. Another reason is that writing records is probably a one at a time function, whilst reading is often done as lock operation. "Jaylin" wrote in message ... Would very much appreciate expert advice on why it takes a minute to run a select query, but takes forever to do Make table query on the same set -- Thanks a million for your time and expert advice :-) Jaylin *****Jaylin Message ended******* |
#4
|
|||
|
|||
???Takes very long to do make table query
"Jaylin" wrote in message
... Would very much appreciate expert advice on why it takes a minute to run a select query, but takes forever to do Make table query on the same set Are you going to the end of the SELECT query's Recordset? A SELECT query might look "done", but it will show you a screen of data as soon as it has processed a screen of data. A MakeTable query isn't done until it has processed every row. Chances are the entire SELECT query takes just about as long if you force it to process all rows. There is a difference where the MakeTable actually has to write data to disk, but you might be seeing more of a difference than what really exists. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
Thread Tools | |
Display Modes | |
|
|