What is more efficient of the two

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

What is more efficient of the two

Message

From

12/07/2006 05:26:24

Bhavbhuti Nathwani
Venus Software Operations
Rajkot, India

All

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

What is more efficient of the two

Environment versions

Visual FoxPro:

VFP 8 SP1

Database:

MS SQL Server

Miscellaneous

Thread ID:

01135592

Message ID:

01135592

Views:

Hi all

What is more efficient:

SQL PT dataset (variable no of records but within a range of records)
INDEX on a field

SCAN
   SEEK(in "MySQLPTCursor")
   Do other stuff
ENDSCAN

SCAN
   SQL PT single record as needed
   Do other stuff
ENDSCAN

Please advise.

Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
___________________________________________
venussoftop@gmail.com
___________________________________________

Map

View

Click here to load this message in the networking platform