Larry I am using a copy of the 7.5 db that I just converted using Turbo and Unloaded All. So the Index structure is 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? Marc From: Lawrence Lustig Sent: Monday, May 04, 2009 2:22 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: 7.5 vs V8 speed << The command below takes almost 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 >> List the table in both databases and look for a missing index on TR_DATE or InsCo in the V8 version. -- Larry
