6 Jan
2010
6 Jan
'10
3:31 p.m.
Alan Buxey <A.L.M.Buxey@lboro.ac.uk> wrote:
I guess I am a 'small cheese' with only 2m rows in my authentication table? I am using PgSQL and have btree'd my timestamp columns, but it still takes only 3.6s to pull 10k rows worth of just todays data.
ah..you have the immediate advantage of postgreSQL
For me it's the CIDR syntax: SELECT * FROM dot1x_auth WHERE nas_ip_address <<= 1.2.0.0/16 Cheers -- Alexander Clouter .sigmonster says: The price of greatness is responsibility.