Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight

Re: (Ovid) Re: Re: Refactor method calls or not?

by mpeppler (Vicar)
on Jan 19, 2002 at 04:45 UTC ( #140017=note: print w/replies, xml ) Need Help??

in reply to (Ovid) Re: Re: Refactor method calls or not?
in thread Refactor method calls or not?

That's a similar architecture to what we did at eCircles. We decided to create logical database "requests" that mapped to one or more stored procedure calls with explicit input and output variables.

This means that the application code doesn't know anything about the database - it only knows about these database requests, which allowed us to decouple the applications from the database somewhat.

As for transactions, with Sybase at least we managed to never have a transaction that spanned multiple database requests. I realize that this may not always be possible, but keeping transactions short helps tremendously on general throughput for the database.


  • Comment on Re: (Ovid) Re: Re: Refactor method calls or not?

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (3)
As of 2021-04-23 00:14 GMT
Find Nodes?
    Voting Booth?

    No recent polls found