It is a temporary table, so I do not usually use indexes on temporary tables. I am just wondering why it is so slow to update a temporary table. It should be fast. Dan Goldberg _____
From: [email protected] [mailto:[email protected]] On Behalf Of Dennis McGrath Sent: Wednesday, November 04, 2009 12:33 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: space in zipcode Since it is a temporary table he can do just what Larry suggests, regardless if STATICDB is on. Dennis McGrath _____ From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen Sent: Wednesday, November 04, 2009 2:26 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: space in zipcode Caveat, In reference to the ongoing discussion of QUALCOLS and STATICDB, DROP indexname is not available if you are running with STATICDB ON. Jan -----Original Message----- From: Lawrence Lustig <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Wed, 4 Nov 2009 12:17:17 -0800 (PST) Subject: [RBASE-L] - Re: space in zipcode << Thanks Bob and Buddy. I did both of those you recommended and it sped it up but still takes alot of time. It is a big(727,000 rows) temporary table. >> If that field is indexed, or participates in a multi-column index, drop the index before you issue the update, then recreate it afterwards. -- Larry
