Re: How would the God of Standard Sql - Celko do server side paging?

What do you think happens when you click page 6 or 9 at the bottom of the [Google] results? Do you think it calculates all 141,000 rows again, and presents them again, merely hiding all but the 10 you're currently looking at? <<

No, I think that first my query is checked against other previously
computed query results sets. A lot of people Google "<movie star
name> bikini" when that <movie star name> appears in the news today.
I don't get nearly as much traffic as Paris Hilton -- go figure! Oh
wait; I have seen pictures of myself in a Speedo.

Then using the same model as a report server, the compressed result
set is passed to my desktop. My desktop/iPhone/whatever holds as much
of results as possible locally, decompresses it and figures out the
display and pagination on my end, locally. Those Chinese fonts are on
my machine. My Niece's iPhone is not the same size or colors as my
desktop.

If I ask a truly original query of Google, it can take awhile. But
Map & Reduce is darn good for indexed text. That new result set is
then held, maybe mirrored, and we get a count as to how many times
other people want to see it or a query which contains it. Did you
notice that "Celko" and "Celko Joe" both took about 0.21?

After a time when there is a loss of interest, the result gets flushed
from the middle tiers to make room for "<new movie star name> bikini"
results. Just like last month's reports are flushed from the report
server for the current reports. Google is a VERY tiered
architecture.

Now, consider that not everyone has the budget for a separate reporting server, or the ability to invest in implementing (or writing their own) technologies like memcached etc. that can distribute data across tiers. <<

Just for fun, I Googled up the current prices for Crystal Reports 9:

Crystal Reports 9 - Professional Edition $495
Crystal Reports 9 - Developer Edition $595
Crystal Reports 9 - Advanced Edition $1995
eLearning Course for Crystal Reports 9 (CD-ROM) $149

You can probably do better than this, or get another product. This
retail price is less than the cost of a nice office desk and chair.
If I work a programmer a 40 hour week, then one week at $50/Hr is the
cost of an Advanced Edition. If it doubles his productivity, then I
am ahead.

A million rows is not exactly reserved for multinational corporations with 7 figure data center costs, and it is ridiculous to tell these people that they must send all million rows to the "reporting server" and have it deal with this problem every time. <<

No! The point is that you send the million rows to the report server
ONCE. It formats them. It distributes them with all kinds of
formatting and computations on demand or on subscription. It does not
have to cache them in main storage, or even a fast disk. The disk
just has to paint a screen or feed a printer without being seen as
slow by a human being. That is usually easy.

Meanwhile back at the Database (sorry, American joke referring to old
1950's Western Movie Serials that always had a caption on the screen
that said "Meanwhile back at the Ranch.." as a scene transition) I am
doing "DB Stuff" -- insertions, ad hoc queries, stat analysis, DQ
audits, etc.

Is your "reporting server" that many more times more powerful than your database server, that it can afford to slice and dice million+ row data sets to show 10 at a time to every client that is asking for it? <<

Unh? All it does is some simple math and string handling, then the
pagination is pretty simple. Now if I get a graphics package to do
pie charts, etc. I will need a good printer, high rez screens,

I don't know why you have such a hard time believing that paging is a real business need outside of your SQL for Smarties classroom mindset. <<

And I don't know why you have such a hard time believing that paging
is a simple task for a front end that knows what the hardware looks
like. An iPhone can do it!!

.

Relevant Pages

  • Re: Google Architecture
    ... I'm always amazed when Google ... reformulate the query. ... Contrast this model to a traditional business enterprise I once worked at. ... If a report listed erroneous matches, ...
    (bit.listserv.ibm-main)
  • Dynamic Reports
    ... I have a query which pulls the data fine, ... textbox I get a wierd printing error (not on google). ... Is there anyway I can make a report to do this? ...
    (microsoft.public.access.reports)
  • Re: Populating a list -- table structure?
    ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
    (microsoft.public.access.forms)
  • Re: Fields in Label dont give correct information
    ... You need to create a query based on tblRegEvent and tblRegPayment. ... -If your DCountis to count values in your report, ... half the time with very few errors (other than that label problem I had.) ... For example in the Room assignment on the report an idividual will be ...
    (microsoft.public.access.reports)
  • Re: Tips on domain aggregate replacements
    ... This already is a split db, but the users are 400 miles away from the server hosting the data:) They are all running the same copy of the FE locally on a single terminal server via TS/RDP sessions. ... It doesn't seem to have much impact on performance; the report takes just about as long to run if they are all logged in as it does when I am logged on testing it at night. ... I would do DSums from the controls on the report on the data returned by the query. ... The biggest offender is a certain report that needs to Sum a particular complex total for each of the next twelve months (the DSum in VBA was a sideline to this issue) and present these as items on each line of output. ...
    (microsoft.public.access.modulesdaovba)
Loading