Marc: Have you tried using a permanent table in 7.5 to see if it's faster than using the temp table? And if you're using temp tables, make sure your scratch setting is to a local drive (like SET SCRATCH C:\TEMP) so that temp table information is kept local rather than traveling through the network.
Karen > 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 >
