Insert into table from Memvar is too slow for Fox? - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Insert into table from Memvar is too slow for Fox?

Message

From

13/10/2003 17:09:51

Joel Hokanson
Services Integration Group
Bellaire, Texas, United States

To

All

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

Insert into table from Memvar is too slow for Fox?

Miscellaneous

Thread ID:

00838321

Message ID:

00838321

Views:

99

This code is in a Do while that steps down through a Fox table.

INSERT INTO sql_jdearfeederrecords FROM memvar
WAIT WINDOW "Updating" TIMEOUT 5

If I do not have the wait of a full 5 seconds, the next pass through I get an error say "Connection mydsn is busy"

Is FOX just too fast for SQL 2000?

using VFP 8.1 SQL 2000

Click here to load this message in the networking platform