Re: Faster loading

It's true that datasets are incredibly slow. Nothing you can do about that.
However, Business Objects has admitted to this fact and rewrote the dataset
processing library for CR 10 and .NET 2005. So they are much faster now. If
you upgrade to CR 2005 when it comes out then you will see improvements.

HTH

Brian Bischof
www.CrystalReportsBook.com




"Richard Dudley" <rjdudley@xxxxxxxxx> wrote in message
news:Oo7Jriy0FHA.2932@xxxxxxxxxxxxxxxxxxxxxxx
> For very simple stuff, I would agree that CR directly querying the
database
> is (PULL method) is probably quicker than loading a dataset and binding to
> that (PUSH method). However, absolutely nothing I do in reality is that
> simple, and I've found that datasets work much better for me. My queries
> usually involve several joins and exclusions which are passed as
parameters,
> and SQL Server is best for that.
>
> It really depends on what you're doing. Concievably, you could create
views
> for most things and PULL from those. While CR can filter and sort data,
> it's really a presentation mechanism. While you can do data presentation
in
> SQL Sevrer, it's really a filtering and sorting mechanism. I put the work
> with whatever is best for doing the work.
>
> "Nathan M" <NathanM@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:D0B0F920-0D9E-4591-BC0E-3A891B426DCD@xxxxxxxxxxxxxxxx
> > Hi,
> >
> > I use CR for VS.NET 2002. I've heard that a report linked to a database
> > will load faster than linking it to a dataset. Is this true? I'm
linking
> a
> > report to a dataset, and it takes up to two minutes to load on a 1.6 Ghz
> with
> > 512 MB RAM, and a really long time on slower computers. A lot of folks
> who
> > may be using my program may be using slower computers, and I don't want
> them
> > to wait forever for the report. CR doesn't do anything with the data
> except
> > group and sort it--all the querrying is done on the dataset side.
What's
> the
> > fastest way to get the data to load?
> >
> > Thanks
> > Nathan
>
>


.

Relevant Pages

  • Embedded Images
    ... If I embed an image on a form or a report does that mean I no longer have to keep the directory that contains the images? ... In other words if I load my Access application on another computer will the images still show up without me having to load all of the images as well? ... Is there any advantage embedding as opposed to linking? ...
    (microsoft.public.access.formscoding)
  • Re: Linux, X, ld, gcc, linking, shared libraries and stuff
    ... which is similar to "lazy binding"...but goodness knows what linker ... way of the "paging mechanism" to only load those pages which are actually ... > patch the pointer thereafter (i.e., dynamic linking). ... mechanism _IS_ there with Windows (though, ...
    (alt.lang.asm)
  • Re: Dapper complete system freeze---could be ati driver or epiphany browser
    ... then on starting x, the monitor would report 'signal out of range', ... Load "GLcore" ... SubSection "Display" ...
    (Ubuntu)
  • Re: MS Access Reports
    ... Print the Report to PDF ... Load the PDF docs into Acrobat and SaveAs to Jpeg format ... Load the doc into the MODI viewer app and SaveAs TIFF. ...
    (microsoft.public.access.reports)
  • Re: where will I notice negative side effects of bloat?
    ... Perhaps you just bind the report to a linked table and pass the parameters ... will it take longer to load the 20MB bloated app than it will to ... load the 8MB compacted app? ... you substantially increase the chances of corruption as now there are ...
    (comp.databases.ms-access)