Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: oracle - mysql comparison
VC wrote:
> "Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
> news:1090216505.569999_at_yasure...
>
>>I think your understanding of Oracle is rather slight based on what I >>assume you mean.
Ok bluntly ... I don't think you know what you are talking about. A lot less vague but I'd have preferred not to say it in those words.
>>How in mysql can you obtain a result consistent to point-in-time without >>table locking all resources.
Same statement is true for both DB2 and MS SQL. You can not create a point-in-time consistent read without full table locks on all resources.
> As to mysql, the answer to your question is truly simple: MYSQL has (and
> has had for quite a while) an implementation of Oracle style 'read
> consistency' with rollback segments and all.
Since what version?
>>And in Oracle ... I would like a demonstration of how would go about not >>having a point-in-time consistent result without intentionally >>corrupting a query result.
I'm saying you can't, without intent, create a query result that is not read consistent to a point-in-time.
Daniel Morgan Received on Mon Jul 19 2004 - 07:28:46 CDT