Alex Tweedly wrote:
I'd consider compressing the file (depending on what other uses it is being put to). Guessing each field at an average 20 bytes, you have 1000 * 15 * 20 = 30kbytes - could compress to 10-20K depending on data, and so half the transfer time.
Oops - failed Arithmetic 5 (That's Arithmetic 101 for you guys in the US)
1000 * 15 * 20 = *300* kb
Definitely SQL is looking like a good bet, depending on the access pattern esp. for reads. If you are reading without searching, does that imply the client needs all, or most, of the data from the file ? If so, simple (compressed) text transfer may be the way to go.
-- Alex.
No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.7.3 - Release Date: 24/01/2005
_______________________________________________ use-revolution mailing list [email protected] http://lists.runrev.com/mailman/listinfo/use-revolution
