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

Ken Schaefer ken at adOpenStatic.com
Tue May 25 19:49:58 CDT 2004


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Richard Bennett" <richard.bennett at skynet.be>
Subject: Re: [thelist] is there something like eval() in my sql?


: On Tuesday 25 May 2004 17:08, david.landy at somerfield.co.uk wrote:
: > richard,
: >
: > >I was hoping to avoid this, as each list is 80.000 records as it is...
: >
: > why were you hoping to avoid this? what database are you using,
: mySQL for this.
:
: > and does it
: > have a maximum number of rows? on most db's (even access) if you
optimise
: > your indexes properly the size of the table will not be a performance
: > issue, and tables with millions or tens of millions of rows will
function
: > just fine. try it and see.
: 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



More information about the thelist mailing list