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

[Jewel Mlnarik]

Not sure if it was mentioned yet, but you can run an explain on your query
for more information on how your sql engine is processing the query.
Usually you can use this to futz around w/your sql until you get an
efficient one.  I know it works with postgres and mysql and pretty sure you
can use it in ms sql even though I never have used that particular db.
http://archives.neohapsis.com/archives/dev/sapdb/2003-q3/0230.html  may have
some more helpful info as well.  Good luck.

~ jewel

>-----Original Message-----
>From: Richard Bennett [mailto:richard.bennett at skynet.be] 
>Sent: Wednesday, May 26, 2004 12:53 AM
>To: thelist at lists.evolt.org
>Subject: Re: [thelist] is there something like eval() in my sql?
>
>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.
>