Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Use cursors with tablebuffering
Message
From
12/12/2003 12:48:48
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Use cursors with tablebuffering
Miscellaneous
Thread ID:
00858664
Message ID:
00858664
Views:
55
Hi,

AFAIK, On VFP Buffering is implemented with this schema:
|				DATASESSION                              |
|									||
||          WorkAreaX             |	|         WorkAreaY             ||
|----------------------------------	---------------------------------|
||  WA status (RECNO(),FILTER..)  |	|  WA status (RECNO(),FILTER..) ||
||  WA buffering Data             |	|  WA buffering Data		||
||  WA buffering Index            |	|  WA buffering Index		||
|----------------------------------	---------------------------------|
|                |			                |		 |
|                |			                |		 |
|                |--------------------------------------|		 |
|				     |					 |
|			             |					 |
|	              ---------------------------------			 |
|       	      |    ????    CACHE/LOCK  ????   |			 |
|                     ---------------------------------			 |
|					|				 |
|---------------------------------------|--------------------------------|
					|
					|
				      FILES
This schema have a limit:
- i cannot use a cursor with tablebuffering and edit the data on two grids;
- is not possible define new index tags for cursors with tablebuffer.

Questions: where is useful this schema ?

If VFPT read this, i known new VFP9 behaviour ( probable ) for SQL-SELECT
with buffering data query, then, you can to take in consideration this
schema :
|			      DATASESSION                              		|
|										|
||          WorkAreaX             |	|         WorkAreaY             |	|
|----------------------------------	---------------------------------	|
||  WA status (RECNO(),FILTER..)  |	|  WA status (RECNO(),FILTER..) |	|
|----------------------------------	---------------------------------	|
|		|					|			|
|		|					|			|
|		-----------------------------------------			|
|				    |						|
|				    |						|
|		----------------------------------				|
|		|  WA buffering Data             |				|
|		|  WA buffering Index            |				|
|		----------------------------------				|
|				|						|
|				|						|
|		---------------------------------				|
|		|   ????    CACHE/LOCK  ????	|				|
|		---------------------------------				|
|				|						|
|-------------------------------|-----------------------------------------------|
				|
			      FILES
This:
- reduce buffering resources;
- can increment USE command speed
- for cursor ( or exlusive tables ) with tablebuffering is possible define new index tag;
- for new VFP9 SELECT behaviour can to be simple or faster .

Thanks for attention.

Fabio
Next
Reply
Map
View

Click here to load this message in the networking platform