Quote:
Two things:
1) The sleep command I described above should have said "sleep 0.01" not "sleep .01". The latter is not correct syntax and won't work.
2) I noticed that if I run the script nice and slow the records are written to the sql table in the exact order they are sent. As I gradually speed up the script (by decreasing the sleep time) the record writes to the table become more and more disordered, and at some point I just start losing records. I'm thinking now it's a SQL issue--at full speed the script writes about 150 records/sec, which is nothing. I'll have our DBAs look into it. If they find anything I'll post it for other's benefit. Thanks to all for your input.
IMHO, I would remove the GOTOs from your script.. You can probably decrease the size of the script by removing them and incorporate them as FUNCTIONS..
Kent
