Article View: borland.public.delphi.aspdotnet.components.using
Article #27Re: D2005 Datagrid paging
From: James D. Franchello
Date: Wed, 10 Jan 2007 23:02
Date: Wed, 10 Jan 2007 23:02
61 lines
3420 bytes
3420 bytes
> <snip> > > Well it was kinda blunt of me to put it that way, soz for that. No offense taken! > Viewstate isn't the only way to store the dataset, you could also use > the session state. That's a server side object you can put pretty much > anything you like in. But you have to remember that that solution eats > lots of memory on your webserver. I will definitely keep this in mind. I guess this is where the trade-offs start coming in to play as to whether one keeps a dataset in a view state, session state, or simply requery the database. So far I have only kept small items in the session state (like a numeric key - int64). That seems not to be too imposing but perhaps there is a good bit more overhead in just doing that than I suspect. Is there any method of predicting the size of the memory that is consumed by session state info? <snip> > Take into consideration to use MySQL. > MySQL has an internal paging mechanism that allows you to get a > specific "window" of records from a SELECT query. > I have not used MySQL but this sounds interesting - I will look in to it - thanks! > > Actually, I am using the Enterprise version. > Nice, too expensive for myself tho, i'm not making lots of money with > programming, it's more of a hobby for me. I have another full time day > job to make a living.. > Well, ... if it had to come out of my pocket personally ... You do this as a hobby? Now I feel really bad about taking your up time - and - that much more grateful for your generous contributions to these newsgroups - my great thanks again! > > ASP.NET user is the user you need to assign to the directories you > deploy to. > You need to deploy at least Borland.Delphi.dll and any other > non-microsoft dll that's mentioned in the references list of the > project. > more good tips! > But i.i.r.c. from the Enterprise demo i tried, the Enterprise SKU comes > with a deployment tool that creates a bdsdeploy file, whith the tool > you can deploy anything from the project that's required to run it > properly. I have seen it and started to 'play' with it ... do you get the feeling that I am just a slow learner???? Many thanks again! James
Technical Details
Message-ID:
<45a56ff6@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!news.maxwell.syr.edu!newsfeed.yul.equant.net!news-lond.gip.net!news.gsl.net!gip.net!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<459d2f1e$1@newsgroups.borland.com> <45A0CBC6.4090602@chello.nl> <45a2a1ad@newsgroups.borland.com> <45a33994@newsgroups.borland.com> <45a3fc2e$1@newsgroups.borland.com> <45a49c3e$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 21665a,5bca6ea60c26735f X-Google-Attributes: gid21665a,public X-Google-Language: ENGLISH,ASCII-7-bit From: "James D. Franchello" <james@nospam_INTInfo.com> Newsgroups: borland.public.delphi.aspdotnet.components.using References: <459d2f1e$1@newsgroups.borland.com> <45A0CBC6.4090602@chello.nl> <45a2a1ad@newsgroups.borland.com> <45a33994@newsgroups.borland.com> <45a3fc2e$1@newsgroups.borland.com> <45a49c3e$1@newsgroups.borland.com> Subject: Re: D2005 Datagrid paging Date: Wed, 10 Jan 2007 18:02:53 -0500 Lines: 63 Organization: INT Information Systems, Inc. X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 NNTP-Posting-Host: 76.181.83.231 Message-ID: <45a56ff6@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1168470006 76.181.83.231 (10 Jan 2007 15:00:06 -0800) Path: arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!news.maxwell.syr.edu!newsfeed.yul.equant.net!news-lond.gip.net!news.gsl.net!gip.net!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail