Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change

Re: Comparing tables over multiple servers

by hakkr (Chaplain)
on Oct 28, 2005 at 14:51 UTC ( #503671=note: print w/replies, xml ) Need Help??

in reply to Comparing tables over multiple servers

If you can find them you could just stat the modified date and size of the raw datafiles or compare md5 hashes of the files.

Depending on how you can sort the data with sql you may just be able to take a look at the first x rows and/or the last x rows of the table instead of building a complete array.

Also depending on your data you could maybe checksum a column.

  • Comment on Re: Comparing tables over multiple servers

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://503671]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others wandering the Monastery: (3)
As of 2023-02-05 20:00 GMT
Find Nodes?
    Voting Booth?
    I prefer not to run the latest version of Perl because:

    Results (32 votes). Check out past polls.