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

Thanks.
Richard.


More information about the thelist mailing list