caching should be considered a last resort to increasing preformance. other options which can improve through put are: 1. efficient query plans: indexing, low number of table joins, etc. 2. batched queries for reads and writes. 3. paging the data, very rarely (if at all) do you really need 100s of entities for a single operation.
On Mar 10, 7:09 am, Harold Wanyama <[email protected]> wrote: > Thanks Dwarell, I think u have answered my question as I had thought of your > solution but my initial concern was it was too artificial.My initial thought > was that on creating a persistent object it wud automatically go into 2nd > level cache. Ps: the caching concept wasn't wholly ingrained in me I suppose > > On Wed, Mar 10, 2010 at 1:55 PM, Dwarrel <[email protected]> wrote: > > A cache is always caching information not replacing your database, so > > the first time it will have to get things from the database no matter > > what caching you have enabled. Subsequent calls will utilise the 1st > > and 2nd level caches if the item has been used before. Caching does > > not work magic on your initial load. What I tend to do is during the > > initialization phase of my Windows.Forms app I query all lookup tables > > once so that their information is in the 2nd level cache. After this > > any new session will tend to get the object information from the 2nd > > level cache (syscache in my case). Query caches only help when you > > call the same query loads of times with exactly the same parameters. > > The cache will not store the info of these objects though, unless you > > have set the returned class to also be cached. Hope this answers (part > > of) your question > > > On Mar 10, 11:26 am, Harold Wanyama <[email protected]> wrote: > > > Hi Jason, > > > 1.Iam using Syscache implementation on a windows based application. > > > 2.The startup code is created in its own library (Utilities) (thats where > > I > > > created my NHibernateHelper sealed class . > > > 3.Iam caching both entities and queries. > > > > Maybe my question is a bit misleading. My understanding of a cache is > > data > > > storage in memory. My problem is how can I cancel the delay of querying > > the > > > database teh first time my application starts up as the query hasn't yet > > > been cached? > > > Thanks > > > > On Tue, Mar 9, 2010 at 4:38 PM, Jason Meckley <[email protected] > > >wrote: > > > > > 1. what cache implementation are you using? > > > > 2. where is the "startup" code located? > > > > 3. are you caching entities, queries or both? > > > > > "on first time loading I am unable to implement 2nd level cache and > > > > the performance lag is obvious to see." > > > > could you clarify. cache, by definition, will expire periodically. > > > > Therefore there will be times when the database is queried. > > > > > On Mar 9, 4:43 am, Harold Wanyama <[email protected]> wrote: > > > > > Hi guys, I have so far been able to use 2nd level cache and it works > > fine > > > > > albeit with one problem. When the application starts, and I query a > > list > > > > of > > > > > obects from the database, on first time loading I'am unable to > > implement > > > > 2nd > > > > > level cache and the performance lag is obvious to see. But on 2nd > > time > > > > > loading and onwards 2nd level cache is used and the speed is much > > faster. > > > > > How can I solve this problem? I can rephrase by saying If I create a > > > > > persistent object , how can I cache it ?? > > > > > -- > > > > You received this message because you are subscribed to the Google > > Groups > > > > "nhusers" group. > > > > To post to this group, send email to [email protected]. > > > > To unsubscribe from this group, send email to > > > > [email protected]<nhusers%[email protected]> > > <nhusers%[email protected]<nhusers%[email protected]> > > > > > > > . > > > > For more options, visit this group at > > > >http://groups.google.com/group/nhusers?hl=en.-Hide quoted text - > > > > - Show quoted text - > > > -- > > You received this message because you are subscribed to the Google Groups > > "nhusers" group. > > To post to this group, send email to [email protected]. > > To unsubscribe from this group, send email to > > [email protected]<nhusers%[email protected]> > > . > > For more options, visit this group at > >http://groups.google.com/group/nhusers?hl=en. -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
