Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling

Re: Connection Pooling

by Laurent_R (Abbot)
on Jun 10, 2013 at 11:15 UTC ( #1038049=note: print w/replies, xml ) Need Help??

in reply to Connection Pooling

I don't know if this will help in your case, but I had a few years ago a somewhat similar case: a euro migration of a relatively large database with about 120 or 130 tables having monetary values to be converted to the new currency. My responsibility was to validate the data quality after the migration. What we did is simply to dump the tables (or the relevant fields of the tables) into flat CSV files before and after the migration and then just read the files in parallel to compare the monetary values and check their conversion. This turned out to be more practical and much faster than using database indexes to access the data. But, because of the nature of the migration, we were guaranteed to have the data dumped in the same order into the files, making further processing very easy. This might or might not apply to your case.

Replies are listed 'Best First'.
Re^2: Connection Pooling
by venu_hs (Novice) on Jun 10, 2013 at 13:08 UTC

    Any suggestions, please let me know asap.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1038049]
[LanX]: Eily: nit picking: Assurancetourix!
[karlgoethebier]: We also have Costa Nix
[Eily]: indeed
[LanX]: I like http://www.comedix .de/lexikon/db/ nihamavasah.php = never have we water and http://www.comedix .de/lexikon/db/ erindjah.php = Air India xD
[LanX]: work!
[LanX]: thats very strange, I try to change two columns to "unique" and MySQL is complaining even that the data is already unique ???
[karlgoethebier]: Angie Singing

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (10)
As of 2017-05-24 15:33 GMT
Find Nodes?
    Voting Booth?