Hi,
one more letter about RDDSQL. Actually it was not asked yet, but I feel
it is a naturally the next question.
Does RDDSQL supports indexing?
The answer is: Yes and No. :) Well, actually I would say much much more
Yes, than No.
RDDSQL DOES NOT generates hidden queries. Code:
DBUSEAREA(.T.,, "select * from table", "table")
INDEX ON SOMEFIELD TAG somefield TO table
do exactly that it is asked for. SQL query will be:
select * from table
but NOT:
select * from table order by somefield
After query result is obtained, it will be indexed in memory. RDDSQL
implements a real b-tree indexes just like cdx or other indexes. So, you
will do DBEVAL() with expected order of records. If you want to do
ordering on server side, please, add "order by ..." to SQL query.
Regards,
Mindaugas
_______________________________________________
Harbour mailing list
[email protected]
http://lists.harbour-project.org/mailman/listinfo/harbour
