This is the second office that has brought up the issue of Rbase getting slower as the day wears on.
This tech is a certified network guy so I assume the network is OK, new computers 1 gig switches ... My old code used a regular table and I would just delete rows .....but I never heard a complaint on the speed -- tran_spd is a temp table that is created on start of the main menu DELETE ROWS FROM tran_spd -- APPEND .... using append instead of insert does not seem to make any difference INSERT + INTO tran_spd (custnum,date_con,tr_date,tr_type,ch_code,ch_price,+ ptest,dig_ch,memo,treat_dr,inscomp,inshold,modf1,modf2,modf3,+ modf4 ) SELECT custnum,date_con,tr_date,tr_type,ch_code,ch_price,+ ptest, dig_ch,memo,treat_dr,inscomp,inshold,modf1,modf2,modf3,+ modf4 FROM speedov WHERE custnum = .vaptcust EDIT USING spdyov2 + WHERE tr_type = 1 AND custnum = .vcust CAPTION .vcap Then then click a button to Save or append these charges to another table then go back to this same EEP again. Even if I drop Temp tab and Project Temp tab is not faster I think is it my program logic not 7.5, but my old permanent table in 6.5 was faster than the temp table in 7.5 Why would using Temp table be slower? Marc
