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

Re: Testing & Databases

by diskcrash (Hermit)
on Jan 28, 2004 at 21:09 UTC ( #324786=note: print w/ replies, xml ) Need Help??

in reply to Testing & Databases

Dear domm,

This may not be wise or applicable in your case, but here is what we did for a real time test. We wanted to assure ourselves that the live, production database was active and all connections to it were up, so we created the "A Test" or acceptance test. It ran from the client side systems and software, through all communications and then wrote rows in the database. We added a field that was a "test flag" to all rows, which is a minor amount of overhead. We could write a few rows, query them, check for turnaround time, then select and delete them by their "test flag" status.

Thus we could redo the test anytime and recover to a previous state. This is not good in all circumstances, but is very useful to assure the production database was up and in a good state.


Comment on Re: Testing & Databases

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (6)
As of 2015-11-25 05:33 GMT
Find Nodes?
    Voting Booth?

    What would be the most significant thing to happen if a rope (or wire) tied the Earth and the Moon together?

    Results (671 votes), past polls