Larry Just a thought does your scratch folder have a lot of files. if so that be slowing you down a little.
Buddy From: 'Lawrence Lustig' via RBASE-L [mailto:[email protected]] Sent: Monday, January 16, 2017 12:45 PM To: [email protected] Subject: [RBASE-L] - ALTER TABLE slow in RB XE? I frequently use code like this in the BEFORE START eep of forms: PROJECT TEMP ttblMyTable FROM MyTable USING ALL WHERE LIMIT = 0 ALTER TABLE ttblMyTable ADD COLUMN MyColumn1 TEXT(10) ALTER TABLE ttblMyTable ADD COLUMN MyColumn2 DATETIME . . . ALTER TABLE ttblMyTable ADD COLUMN MyColumn25 INTEGER There can be a lot of the ALTER TABLE commands. In R:Base 7.6 this seems fairly fast. But in R:Base XE each alter table command takes nearly a second to execute. This is with STATICDB ON, so there shouldn't be any need to go to disk to check column definitions. I know I can work around this using one large CREATE TEMP TABLE command in place of the the PROJECT / ALTER sequence and that's what I've started to do. But I like the convenience of always getting all columns from MyTable in the provided code. Is there any thing I can SET or do to get back to the R:Base 7.6 speed for ALTER TABLE? -- Larry -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected] <mailto:[email protected]> . For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
