Wednesday, February 17, 2010

Temporary table residing tier

Temporary table resides on the tier where the first insert happened into it. Since temporary table data generation usually requires quite a lot of database transactions it makes sense to instantiate it on the server. However, if a temporary table is displayed on a form it makes sense to instantiate it on the client to avoid chattiness during displaying of the form. But anyway with such approach there will be a lot of client-server calls either during data generation or during displaying. To avoid that the following approach can be used:
  1. Create a temporary table instance on the server and fill it with data.
  2. Place all records from the table to a container and pass it to the client.
  3. Create a new temporary table instance on the client and fill it with data from the container.
  4. Use the client temporary table instance to display on a form.

4 comments:

  1. They say, seeing is believing, if I was told about this contents i would not have believed it and now seeing it myself has proven to me that your guys knows what you’re doing; great contents here.
    9credit Loan App – Download, Installation, Login, & Loan Request (2022)

    Okash Loan App Download For Android And iPhone

    Loan Money Apps where you can loan money at avery subsidized rate.

    ReplyDelete