this is a repost of a question i posted earlier this month to the hardware section (http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Windows/XP/Q_23434435.html
Explanation of problem:
Windows Xp Machine, running Crystal reports 8, SQL Server 2000
We Have a Label (printed ona Zebra Z4M printer) which gets it's data from a stored procedure in a SQL Server 2000 database. This label looks at one table and prints labels based on the criteria in the stored procedure.
We've noticed in Windows XP that the spooling of the label from Crystal to the printer (via LPT1) has slowed up dramatically. Initially the problem manifests itself with gridlines on the label not printing using Zebra version 2.4 driver. I have tried using Seagull Scientific Drivers and Nice Drivers, when i use these drivers, the gridlines re-eppear but the spooling slows dramatically.
I can absolutley say it is not the printer as i have created a blank label with no database lookup and speed is perfect.
I can say that the issue is not with the SQL Server stored procedure/table as I have deleted every record in the table and re-inserted 5 rows to print but the issue still occurs.
If i change operating System to Windows 2000 no issue occurs, be it with speed or gridlines not appearing, everything is perfect.
Any help is very much appreciated.