about retrieving, modifying and updating data using Asp with minimum calls to server
How can data from database (from more than one table) be read into a client
code modified and written back (updated) to the data base with minimum calls/cisits
to the server.
unto client variables modified and then written back to the database.
if there is , what is the way to code the functionality?
kindly aprise me at the earliest.
Re: about retrieving, modifying and updating data using Asp with minimum calls to server
"AnandaTirtha.NR" <firstname.lastname@example.org> wrote:
>How can data from database (from more than one table) be read into a client
>code modified and written back (updated) to the data base with minimum calls/cisits
>to the server.
My first suggestion is that any retrieving of data by grouped together.
What I mean by that is to create views/queries which group the information
you are looking for into one database call and use that to minimize your
retrieval of data.
My other suggestion only applies if you are using a database server with
stored procedures. Use them to minimize the number of calls to update data.
Also good for speed. I don't know if you can call Access functions from
ASP pages (haven't tried), but it may be worth looking at.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL