Originally posted by manish ahuja:
This works fine but our client has come up with the request of completely dismantling this database roundtrip business.
The soul is dyed the color of its thoughts. Think only on those things that are in line with your principles and can bear the light of day. The content of your character is your choice. Day by day, what you do is who you become. Your integrity is your destiny - it is the light that guides your way. - Heraclitus
... so through out the life-cycle flow the application has to frequently do a round trip to the database fetch values, persist data and again read back ...
Yes the web service invocation is just 1 call.
The database interactions is part of the internal logic of the application.
Originally posted by James Clark:
An alternative to creating an object-based memory database would be reduce the number of database calls. This can be accomplished by writing more efficient SQL statements and/or using stored procedures and/or modifying the relational model.
The soul is dyed the color of its thoughts. Think only on those things that are in line with your principles and can bear the light of day. The content of your character is your choice. Day by day, what you do is who you become. Your integrity is your destiny - it is the light that guides your way. - Heraclitus