Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP and Seagate Crystal Reports
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00149927
Message ID:
00151547
Vues:
23
>I made a small application. It worked fine ! It took 2 fields out of a table of
>28.000 records and displayed them. The speed of the application was horrible :
>it took 20-25 seconds to open the Crystal report and another 10 seconds to only
>read the first 100 records.
>How can I make the process faster????

How's your memory? That could be slowing it down quite a bit...

>Mr Berntson suggested to create a FXP2.x table of my data (almost all my
>tables) but by doing that don't I make the tables unreadible to VFX6.0 ?? How
>can I easilly convert my tables to another format(FXP2.x)?

It wouldn't make them unreadable, as George pointed out, but if you just select the actual data you want, and then convert _that_ file using COPY TO tmpData TYPE FOX2X, you would get a bit better speed on the other end.

>Is making another databaseformat no option ?? To convert my database to say
>Acces format and make Crystal report read and use it a lot faster.

I wouldn't...

>I compared the creating of a report with Crystal reports and from the VFP6.0
>Report Designer. Visual FoxPro is a lot faster !!!

That wouldn't surprise me: it's a question of power. If you can do your report in the VFP Report Writer, do it: if you need the power that Crystal gives you, you sacrifice a bit of speed.
My blog
My consulting page
My home page

Member of the Trim Your Auto-Quote Campaign!
What's another word for thesaurus?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform