Re: Datasets fundamental

Answers inline with queries.

<shyamspandey@xxxxxxxxx> wrote in message
news:1149677795.725421.249110@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi there!

I'm very new to dot net envirnoment and have little bit understanding.
Due to some reason, I need to work straight forward on datasets and
webservices and xml. I don't have much hold on the same but would
appreciate if someone put lights on the given questions:

a) How datasets which has passed by value can be retreived from cache?

Default ASp.NET caching? Not really a viable option in a web service
scenario, as you are talking a stateless environment. You could cache
commonly used items, if you can identify them, but in most cases the DB
engine is better at caching than you. Am I missing somethign?

b) How would one know whether datasets is containing any records or
not? Is there any way to test the same? Please let me know via coding.

Single table dataset:

if(dataSet.Tables[0].Rows.Count != 0)
{
//Do something, as there are records
}

c) How long datasets will store in server memory?

This is a "it depends" answer, as you never know when garbage collection
clears things out. From the standpoint of access, unless you cache them or
stick them somewhere, they are gone after they are passed on.

d) How to create a dataset and publish it in cache?

For a web service, you can cache with

Cache["nameOfDataSet"] = ds;

I am still not sure what you are caching, or where ... much less why.

Beside this, I do have other questions which will not fall into this
group like :

1) How to map datasets records to update a MYSQL Server?

If you use the standard ADO.NET methods, you link up the SELECT, INSERT,
UPDATE and DELETE queries to your DataAdapter and call Update(). As long as
you either have a query or a stored procedure (I think MySQL has this in its
latest incarnation).


--
Gregory A. Beamer

*************************************************
Think Outside the Box!
*************************************************


.

Relevant Pages

  • Re: Separating static and dynamic contents?
    ... you are confusing caching content with caching database ... If you cache content, you put a caching proxy server between your ... If you cache queries, you simply turn on query caching in the MySQL ...
    (comp.lang.php)
  • Re: Caching for "LIKE" queries?
    ... next user queried "harry potter", would any caching have been done, as ... I'm wondering if I should implement a cache at the ... application level (or in the database, since all the queries are ... Puget Sound Oracle Users Group ...
    (comp.databases.oracle.server)
  • Caching for "LIKE" queries?
    ... next user queried "harry potter", would any caching have been done, as ... I'm wondering if I should implement a cache at the ... application level (or in the database, since all the queries are ... the database will take care of that for me. ...
    (comp.databases.oracle.server)
  • Re[2]: [PHP] dynamic -> static
    ... As I wrote already this issue is mainly because of search engines ... incompatibility with dynamic content sites (to be more exact - with ... You can cache your code using PHP Accelerator or Turck ... MM> implementing a caching layer between your application and your database. ...
    (php.general)
  • Re: [PHP] Aggressive PHP Smart Caching
    ... i have begun to experiment w/ your caching tool. ... it is also important that the script calling ob_end_flushhave access to ... the header method in the first bit of code in the cache tool. ...
    (php.general)
Loading