Re: [AMaViS-user] idea for SQL database storage...

2005-07-27 Thread Mark Martinec
Ed, > Instead of storing the client_addr as a VARCHAR(255), how about > storing it instead as a 32bit number in a column of type UNISIGNED > INT? This'll reduce storage and speed queries. > > MySQL can convert back and forth using inet_aton and inet_ntoa. > Perhaps there's something similar for p

Re: [AMaViS-user] idea for SQL database storage...

2005-07-11 Thread Stuart Johnston
Ed Walker wrote: Instead of storing the client_addr as a VARCHAR(255), how about storing it instead as a 32bit number in a column of type UNISIGNED INT? This'll reduce storage and speed queries. MySQL can convert back and forth using inet_aton and inet_ntoa. Perhaps there's something sim

[AMaViS-user] idea for SQL database storage...

2005-07-08 Thread Ed Walker
Instead of storing the client_addr as a VARCHAR(255), how about storing it instead as a 32bit number in a column of type UNISIGNED INT? This'll reduce storage and speed queries. MySQL can convert back and forth using inet_aton and inet_ntoa. Perhaps there's something similar for postgres