Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ADO access slow
Message
 
À
03/09/2003 03:28:32
Barry Newton
Plan International
London, Royaume Uni
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00825572
Message ID:
00825685
Vues:
24
Crystal Reports will allow you to report on the dataset.

>Hi
>I've connected to a datasource using ADO and OLEDB (on an Advantage server) but when I try to get the data into a cursor the access seems rather slow.
>
>This is my code to get at the data:
>cConnectString = [Provider=Advantage.OLEDB.1;]+;
> [Data Source=C:\TEMP\;]+;
> [Persist Security Info=False;]+;
> [Advantage Character Data Type=ADS_OEM;]+;
> [Advantage Server Type=ADS_REMOTE_SERVER;]+;
> [Advantage Table Type=ADS_CDX]
>oConn = CreateObject("ADODB.Connection")
>oConn.ConnectionString = cConnectString
>oConn.ConnectionTimeout = 30
>oConn.Open
>cSQL = "select * from sales"
>oRS = oConn.Execute(cSQL)
>
>The data goes into the RecordSet fine.
>
>Now I want to create a report on the data (n>1000000) but when I try to transfer it to a local cursor for reporting it only seems to transfer at around 100 records every 5 seconds!
>
>Can I REPORT FORM the data from the RecordSet without transferring to a cursor?
Mark S. Swiencki
EPS Software www.eps-software.com
mark@eps-software.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform