[thelist] is there something like eval() in my sql?

Richard Bennett richard.bennett at skynet.be
Wed May 26 02:53:19 CDT 2004

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. 


More information about the thelist mailing list