Web database suggestions

[Alex Tweedly]

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.
-------------- 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