Re: [sqlite] CREATE VIEW or CREATE TEMP TABLE

[Alexander Batyrshin]

I got better performance when started to use TEMP tables with
temp_store = MEMORY.
But everything depends on situation.


-- 
Alexander Batyrshin aka bash
bash = Biomechanica Artificial Sabotage Humanoid

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

Re: [sqlite] CREATE VIEW or CREATE TEMP TABLE

[Alexander Batyrshin]

Offtop: You are trying to make something like statistic for game?
-- 
Alexander Batyrshin aka bash
bash = Biomechanica Artificial Sabotage Humanoid

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

[sqlite] CREATE VIEW or CREATE TEMP TABLE

[P Kishor]

So, I have a series of SQL selects to do, making for a pretty
complicated process. The end result is to be inserted into a new
table.

I can create a VIEW of each step, SELECTing each subsequent result
from the preceding VIEW. Or, I can CREATE TEMP TABLE for each step.
Any pros and cons of one or the other?

-- 
Puneet Kishor

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