For better or worse the update process uses a DELETE then COPY
sequence to update the tables on the site. The DELETE takes place,
table is updated, next DELETE, next table etc.... sometimes the
process isn't being completed as though something is timing out, so I
was looking to a) speed up the whole process and b) park at least a
snapshot of the data up on the server so I can just import it in and
get the site back to functionality.
Its also usually more prudent to do a RENAME then COPY then DELETE ( the
renamed files ) and RENAME back if the transfer failed. That way you
always have a set of data there.. even if its a bit outdated.. its
usually better than no data.
Matthew S. Jarvis
IT Manager
Bike Friday - "Performance that Packs."
www.bikefriday.com
541/687-0487 x140
[EMAIL PROTECTED]
_______________________________________________
EUGLUG mailing list
[email protected]
http://www.euglug.org/mailman/listinfo/euglug
_______________________________________________
EUGLUG mailing list
[email protected]
http://www.euglug.org/mailman/listinfo/euglug
