🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.delphi.aspdotnet.components.using
Article #27

Re: D2005 Datagrid paging

#27
From: James D. Franchello
Date: Wed, 10 Jan 2007 23:02
61 lines
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-mail
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>

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