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
