[Typo3-dev] Code change template cache logic

[Ries van Twisk]

Dennis Cheung wrote:

>I mean, there should a exec_REPLACEquery in TYPO3_DB.
>  
>
Ahh..ok I misunderstood, sounds like a good idea... +1

>Which may use "REPLACE xxx" or "BEGIN....COMMIT;" to implement the logic,
>depends on server support and system configuration.
>  
>
indeed... dbal can habdle that

>
>I agree with Ries van Twisk.
>If it do transaction, it should started from pconnect.
>MySQL not doing that by default config, will typo3 keep in a "quick and
>dirty php/mysql style"?
>  
>
Uuuu yes......

>Dennis
>
>
>On 12/8/05, Ries van Twisk <typo3 at rvt.dds.nl> wrote:
>  
>
>>joachim rinck wrote:
>>
>>    
>>
>>>Dennis Cheung wrote:
>>>
>>>
>>>      
>>>
>>>>I think there is an better way in "REPLACE" statement in mysql.
>>>>
>>>>
>>>>
>>>>        
>>>>
>>>REPLACE is one very nice thing to have in mysql. +1 for that.
>>>      
>>>
>>unfortunately it is not
>>    
>>
>>>covered by dbal functions. correct me if i'm wrong;)
>>>jj
>>>_______________________________________________
>>>
>>>
>>>      
>>>
>>I think that it should be done within a transaction block, not with a
>>propriaty mysql statement.
>>Other RDBMS do support a transaction block so there is no reason to use
>>REPLACE.
>>BEGIN
>>   delete
>>   insert
>>COMMIT;
>>
>>-1 for using REPLACE.
>>
>>Ries
>>_______________________________________________
>>Typo3-dev mailing list
>>Typo3-dev at lists.netfielders.de
>>http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-dev
>>
>>    
>>
>_______________________________________________
>Typo3-dev mailing list
>Typo3-dev at lists.netfielders.de
>http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-dev
>  
>