>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)