Rushmore fails on large tables

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Rushmore fails on large tables

Message

From

10/09/2008 08:50:55

Yuri Rubinov
Philadelphia, Pennsylvania, United States

09/09/2008 16:44:55

Nick Causton
Associated Data Developments Ltd
Romford, Essex, United Kingdom

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

Re: Rushmore fails on large tables

Environment versions

Visual FoxPro:

VFP 9 SP2

OS:

Vista

Network:

Windows 2008 Server

Database:

MS SQL Server

Miscellaneous

Thread ID:

01346200

Message ID:

01346294

Views:

>Hi Yuri,
>
>That code was only an example to indicatate the problem but yes OrdersNoOnly is used exclusively. Also all tables are in same directory.
>
>Nick

Nick,

- what if both tables are open exlusively ?
- what if you change the order of SELECTs ?
- what if you try the first select again, will it process in 50 sec ?

Map

View

Click here to load this message in the networking platform