Hello,
I tried xSharp for the first time and wonder how (for our application essential) local cursor operations are working or if there are plans to support those.
In VFP these operations were very fast when using indexes e.g. on cursor-fields with rushmore optimization. Please find attached "examples.txt".
Br Mario
Local Cursor Operations with SQL and INDEX
Local Cursor Operations with SQL and INDEX
- Attachments
-
- examples.txt
- (2.03 KiB) Downloaded 45 times
Re: Local Cursor Operations with SQL and INDEX
Mario,
We have started adding several embedded SQL commands for VFP.
What should work:
- CREATE CURSOR
- CREATE TABLE
- INSERT INTO, except INSERT TO ... SELECT ...
- REPLACE
What does not work
- DELETE FROM
- UPDATE
- SELECT
Especially the SELECT statement is quite complicated. Not the SELECT on a single Cursor/Table but joined selects are complicated.
We plan to add these in the future. But there are also many other things that we want to add.
Also, the IndexSeek() function is not implemented yet.
So far there has not been very much feedback in this area, so that is why this got a lower priority.
W.r.t. rushmore optimizations: we do not have this yet.
Robert
We have started adding several embedded SQL commands for VFP.
What should work:
- CREATE CURSOR
- CREATE TABLE
- INSERT INTO, except INSERT TO ... SELECT ...
- REPLACE
What does not work
- DELETE FROM
- UPDATE
- SELECT
Especially the SELECT statement is quite complicated. Not the SELECT on a single Cursor/Table but joined selects are complicated.
We plan to add these in the future. But there are also many other things that we want to add.
Also, the IndexSeek() function is not implemented yet.
So far there has not been very much feedback in this area, so that is why this got a lower priority.
W.r.t. rushmore optimizations: we do not have this yet.
Robert
XSharp Development Team
The Netherlands
robert@xsharp.eu
The Netherlands
robert@xsharp.eu