Web database suggestions
alex at tweedly.net
Tue Jan 25 12:20:15 EST 2005
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.
-------------- next part --------------
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
More information about the Use-livecode