On Wednesday 26 May 2004 02:49, Ken Schaefer wrote: > : Yes, but that means you can only query by the indexed fields. > : I have the call data in a MSSql database with 7000.000 records, and it's > > fine > > : if I query by Date or ID, but if I suddenly need a list of calls going to > : france after 9pm, or something, I can forget it. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > I think you need to have a look at your server - your code, and your server > hardware. > > A 900,000 row table that's being queried on a non-indexed field shouldn't > take more than a couple of seconds to be processed on any modern hardware. > > Cheers > Ken I didn't mention 900.000, I said 7.000.000 records and 9PM :o) They are long rows too - the whole database is about 2.5 gigabit. Also, I can't change the design of this database, as it is linked to by existing software. Anyway, it seems I shouldn't need to worry about saving multiple 80.000 record pricelists in the same table, which was the initial issue, so that's what I'll do. Thanks. Richard.