Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Query takes time to get data
Message
De
26/12/2005 06:50:02
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
26/12/2005 04:37:04
Mazahir Naya
Kuwait United Co.
Kuwait, Kuwait
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01080798
Message ID:
01080803
Vues:
13
>hi to all
>after long time.facing one problem.i have to tables
>in first table i have total number of records(14791014) &
>Second table i have total number of records(464419)
>in my form i have 2 grids.when i try to search from this
>two tables & display this information to grid it is taking around 6 minutes to diaplay data.i am using SQL statment.
>anyone can help me on this issue to reduce time

What is the SQL statement?
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform