Jan I am using the latest build. I thought of a Temp table and maybe Indexes but have not tried this yet.
Thanks Marc From: jan johansen Sent: Tuesday, May 05, 2009 10:01 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: 7.5 vs V8 speed Marc, I'm assuming that you are using the latest verison of V8 releasd on 4/20. There was an update last year specifically dealing with V8 indexes. Most of the reported speed issues with V8 have been external (network and Server 2003). While it may seem counter-intuitive, I have actually found some speed improvements by moving away from views and creating temp tables and appending limited data to the temp tables. There are a couple of articles that may help at http://www.razzak.com/fte named Gaining Speed with Programming in R:BASE Speeding Up Multi-User Environments Also I seem to remember John Minyo presenting a paper I think at the 2007 on programming for speed. Jan -----Original Message----- From: "MDRD" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Tue, 5 May 2009 09:25:48 -0500 Subject: [RBASE-L] - Re: 7.5 vs V8 speed The command below takes 2 times longer in V8 compared to the same code in 7.5. PRINT NewForm76D WHERE tr_date BETWEEN 1/1/09 AND .#date AND insco1 = 7 AND compnum = insco1 ORDER BY insco1, custnum, tr_date The report is based on a 6 tab view, Browse all from View using the same where clause only takes 1/4 the time compared to the Print statement. Leaving off the Order by does not make any difference. I am using a copy of the same DB converted to V8, so all data, reports and indexes are the same. I did notice that the #1 file was 46 k now it is 191 k and the # 3 file is almost double the size in V8. Is that normal? I am not sure what to look for next? Thanks Marc
