Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Slow reports in 9.0
Message
De
30/08/2005 07:38:05
Neil Mc Donald
Cencom Systems P/L
The Sun, Australie
 
 
À
30/08/2005 01:38:48
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
01045033
Message ID:
01045082
Vues:
29
Hi,
Try opening the report as a DBF then PACK it (Back it up first).
Check for GROUP BY clauses if they exist.
Check the Code page settings in DBF's.

>After the debacle we all experienced years ago with the HP problem in VFP 3.0, I have a hard time believe the Microsoft would once again punish us on reporting performance. Yeah, the new features are cool to use but it is kind of like driving around in a brand spankin' new Porsche that maxes out at 30 miles per hour (48.28 km/hr!). So, what is going on with this and who signed me up for this torture?
>
>I have a report that in VFP 7 PREVIEWS (not even send it to the printer) in less than 2 seconds. The same report in 90 previews in a "smoke a cigarette" 262 (4 minutes, 22 seconds). Even running in 80 takes a long time. No pictures, no graphics, just text. There are some formulas that call VFP programs to retrieve data, etc. but it isn't anything major.
>
>In addition, if the user actually wants to PRINT, under 80 or 90 it sends a page, waits until the printer prints a page, sends another page, waits, etc. Crazy. Yes...the printer setting is set to spool so don't think i'm trippin out. The only thing that is "unique" is it is a local printer (wow) being sent over a LPT cable. Even printing over a network takes awhile. For those of you interested, the file size under 90 is 3.37 MB and under 7.0 it is 268kb.
>
>My users are royally ticked because they don't understand the "well you should see what this thing really CAN do". Don't get me wrong, I love VFP but this is absolutely crazy. Are there any solutions, tips, payoffs to this debacle or did i miss something in the help file?
>
>Thanks for the help and have a good day-
>
>Geoff
Regards N Mc Donald
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform