>For a customer I have developed several applications. One of them is used to print a number of documents in a batch.
>Normally that applications creates a print within 25 seconds. However, if an other user start accessing the databases as well the batch speed (in fact all speed) drops to 2 minutes per print. Even closing the second application does not bring back the speed to the batch-application.
>
>Background:
>the applications are run from the local drive
>all data is residing on a NT-server
>both pc's are running Windows 95 (both are PII-300/64 Mb Ram)
>the databases are native VFP using DBC etc.
>the data gathering is complex using views
>
>Does any have a clue what is going on? Is this an application item, is it network related?
>
>Ron Brahma

Hi Ron,

After our conversation on monday, i searched for the question you mentioned.

We have had similar problems with report printing. First we thought it were queries going slow, but we found that the actual report form command was the "bad guy". The reason was printerdriver related. The solution was replacing the expr, tag and tag2 memo fields in the report with ""
The code here explains it.

local laarr_files[1,5], lnaant_files, lcfilenaam, lnfile_hdl, lcmacro
if adir(laarr_files,"reports\*.frx") > 0 && Aantal bepalen
	=asort(laarr_files)
	for lnAant_files = 1 to alen(laarr_files,1)
		lcFileNaam = laarr_files(lnaant_files,1) && Filenaam bepalen
		lcmacro = 'USE '+lcfilenaam+' ALIAS Temp EXCLUSIVE' && Exclusief openen als Temp
		&lcmacro
		GO TOP && Alleen eerste record is van belang. 
		Replace Temp.Expr With "" && Memo veld leegmaken.
		Replace Temp.Tag With "" && Memo veld leegmaken.
		Replace Temp.Tag2 With "" && Memo veld leegmaken.	
		PACK && Tabel opschonen
		USE && En vrijgeven
	NEXT && VOLGENDE!
ENDIF

Hope this helps.

Kind Regards,

Wim Dieke
Viaprisma