Re: [sqlite] Performance of JOIN

"Salvatore Iovene" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Could you tell me if this kind of JOIN would be very expensive in > terms of performance? Why don't you set up a test and measure? It may very well be that the extra time taken to perform a join is offset by less dis

[sqlite] Performance of JOIN

Hello, I have a table like this: INT id TEXT t1 TEXT t2 For a lot of rows the pair (t1,t2) is the same, so, in order to save space, it would be better to have two tables like: INT id INT pair_id and INT id TEXT t1 TEXT t2 But, in my case, speed is more importan than disk space, and if I did i

[sqlite] Performance of JOIN

Hello, I have a table like this: INT id TEXT t1 TEXT t2 For a lot of rows the pair (t1,t2) is the same, so, in order to save space, it would be better to have two tables like: INT id INT pair_id and INT id TEXT t1 TEXT t2 But, in my case, speed is more importan than disk space, and if I did i