Durumdara wrote:
>>> C1.) begin read committed
>>> C1.) starting this query
>>> C1.) query running
>>> C2.) begin read committed
>>> C2.) update Lookup set Name = "New2" where ID = 2
>>> C2.) commit
>>> C1.) query running
>>> C1.) query finished
>>>
>>> Is it possible to the first joins (before C2
Hi!
2011/5/12 Albe Laurenz :
> Durumdara wrote:
>>Two table:
>>Main
>>Lookup
>>
>>The query is:
>>select Main.*, Lookup.Name
>>left join Lookup on (Main.Type_ID = Lookup.ID)
>
> hat's not correct SQL, but I think I understand what you mean.
Sorry, the from is missed here... :-(
>
>
>>Lookup:
>>I
Durumdara wrote:
>Two table:
>Main
>Lookup
>
>The query is:
>select Main.*, Lookup.Name
>left join Lookup on (Main.Type_ID = Lookup.ID)
hat's not correct SQL, but I think I understand what you mean.
>Lookup:
>ID Name
>1 Value1
>2 Value 2
>3 Value 3
>
>Many records is in Main table (for example 1
Hi!
Two table:
Main
Lookup
The query is:
select Main.*, Lookup.Name
left join Lookup on (Main.Type_ID = Lookup.ID)
Lookup:
ID Name
1 Value1
2 Value 2
3 Value 3
Many records is in Main table (for example 1 million).
What happens in this case (C = connection):
C1.) begin read committed
C1.) sta
