RE: [sqlite] Question about speed of CASE WHEN

[RB Smissaert]

> Perhaps the alternative form of the CASE statement would be faster

What form is that?

RBS

-----Original Message-----
From: T&B [mailto:[EMAIL PROTECTED] 
Sent: 18 March 2007 12:41
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Question about speed of CASE WHEN

Hi RBS,

> Looking at the fastest way to convert a field in a table and wonder  
> if in
> general an update with a CASE WHEN construction or an update with a  
> join to
> a lookup table is faster.

Perhaps the alternative form of the CASE statement would be faster,  
but I don't know:

case ENTRY_TYPE
        when  9 then 'Issue
        when  2 then 'Note'
        when  1 then 'Encounter'
        when  8 then 'Authorisation'
        when 11 then 'Prescription'
        when  5 then 'Treatment'
        when  3 then 'Problem'
        when 13 then 'Discontinuation'
        when  6 then 'Reminder'
        when 14 then 'Adverse reaction'
        when -1 then 'Unknown'
        when  4 then 'Sub-problem'
        when  7 then 'Battery'
        when 10 then 'Return-Script'
        else ENTRY_TYPE
end

Tom


----------------------------------------------------------------------------
-
To unsubscribe, send email to [EMAIL PROTECTED]
----------------------------------------------------------------------------
-




-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------