Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Query takes time to get data
Message
From
26/12/2005 06:50:02
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
26/12/2005 04:37:04
Mazahir Naya
Kuwait United Co.
Kuwait, Kuwait
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01080798
Message ID:
01080803
Views:
12
>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)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform