Article View: borland.public.interbase.replication
Article #174Re: Replicating with SQLMonitor
From: Craig Stuntz [TeamB]
Date: Wed, 27 Aug 2003 15:03
Date: Wed, 27 Aug 2003 15:03
23 lines
1906 bytes
1906 bytes
Jonathan Neve wrote: > All I would have to do would be parse the output of the SQLMonitor to > turn it into a proper SQL statement, and then log it in a table in > the database. The big advantage of this method is that I can be sure > that the server will get exactly the same statements as the client, > and hence, the results also should be the same. > > Any ideas? I disagree with this "advantage." Imagine one DB with users active, and one DB without other users. Run the same statement on both DBs. The statement on the first DB might deadlock; the statement on the second probably won't. So "merely" running the same SQL does not mean you'll have identical results. -Craig -- Craig Stuntz [TeamB] . Vertex Systems Corp. . Columbus, OH Delphi/InterBase Weblog : http://delphi.weblogs.com Everything You Need to Know About InterBase Character Sets: http://delphi.weblogs.com/stories/storyReader$306
Technical Details
Message-ID:
<3f4cc85f$2@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-06!sn-xit-08!supernews.com!newsfeed.wirehub.nl!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mailReferences:
<3f4c4486@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: f89d7,34b4f8c43c880cd4 X-Google-Attributes: gidf89d7,public X-Google-ArrivalTime: 2003-08-27 08:08:03 PST From: "Craig Stuntz [TeamB]" <cstuntz@vertexsoftware.com> Subject: Re: Replicating with SQLMonitor Newsgroups: borland.public.interbase.replication Reply-To: "Craig Stuntz [TeamB]" <cstuntz@nospam.please [but use vertexsoftware.com to send email]> References: <3f4c4486@newsgroups.borland.com> Organization: Vertex Systems Corporation User-Agent: XanaNews/1.15.6.2 NNTP-Posting-Host: 24.106.104.202 Message-ID: <3f4cc85f$2@newsgroups.borland.com> Date: 27 Aug 2003 08:03:59 -0700 X-Trace: newsgroups.borland.com 1061996639 24.106.104.202 (27 Aug 2003 08:03:59 -0700) Lines: 23 X-Authenticated-User: cstuntz Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-06!sn-xit-08!supernews.com!newsfeed.wirehub.nl!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mail