Paul Hm! Maybe we should ask for enhancement request that delete should be forbidden unless you have at least 6 R:Base trainings combined with 10 years experience and without where clause it should 12 trainings and 20 years of experience! But even that restriction would not help if you are doing without thinking. Glad it was a joke
Any way I would guess Razzak only comment will be: Would you expect anything less! He is always so modest! Gunnar Ekblad Kontema IT AB Hästholmsvägen 32 131 30 Nacka Sweden -----Ursprungligt meddelande----- Från: [email protected] [mailto:[email protected]] För Paul InterlockInfo Skickat: den 10 september 2009 16:58 Till: RBASE-L Mailing List Ämne: [RBASE-L] - R:BASE eXtreme 9.0 Performance Gunnar- I tried your script but miss read it and typed delete instead and before I could hit cancel it was all gone! Using 9.0! Just kidding. It is nice! I am also looking forward to running compiled in my office. In compiled -- the forms,reports, etc . all can/may reside on the LOCAL machine and use only the db for data, a lot less traffic and faster yet. And there is more - but I need to learn what is there already. Sincerely, Paul D -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Gunnar Ekblad Sent: Thursday, September 10, 2009 10:21 AM To: RBASE-L Mailing List Subject: [RBASE-L] - R:BASE eXtreme 9.0 Performance I few days ago I told you I lost my socks in the storm of Razzak blizzard training in Baden. So I bought new ones. Now even those are blown away by the blizzard storm of 9.0_32 I made a small rmd file: -- Performance 7.6 compared to 9.2_32 SET V vt1 = .#TIME SET LINES 0 SELECT ALL FROM ttrans SET V vt2 = .#TIME SET V vt3 = (.vt2 - .vt1) SHOW V vt% RETURN I first run on 7.6 result 36 seconds in 7.6 on 11000 records Then in 9.0_32 < 0 I could not even time it, so I increased the table to 175000 record. Result in 9.0_32 1 second Result in 7.6 well I dont know, I got tired of waiting after 10 minutes so I aborted it. How is that for performance upgrade! Wonderful job of RBTI-Dream team Gunnar Ekblad Kontema IT AB Hästholmsvägen 32 131 30 Nacka Sweden
