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
|
|||
|
|||
Make Table Query takes long time
I'm using a make table query to create a new table from
Paradox tables. There are about 80,000 records in the Paradox tables and the process takes about 30 minutes. Is there a faster way to do this? Any suggestions would be greatly appreciated. Thanks! |
#2
|
|||
|
|||
Make Table Query takes long time
On Mon, 24 May 2004 14:40:48 -0700,
wrote: I'm using a make table query to create a new table from Paradox tables. There are about 80,000 records in the Paradox tables and the process takes about 30 minutes. Is there a faster way to do this? Any suggestions would be greatly appreciated. Thanks! It might not help - especially if the bulk of the delay is due to Paradox; but you might try creating an empty table with the desired field names and datatypes, and running an Append query to load it rather than a MakeTable query. Don't put any indexes on the table until after it's loaded, and compact the database before and after running the append. John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
Thread Tools | |
Display Modes | |
|
|