FiveTech Software tech support forums

Many Thanks Nage
Happy New Year

Marco

Dear Nage this problem has been resolved?

Many thanks

Marco

Happy New Year Otto!

..and Happy New Year!

Dear Ramesh,
in my old post slowness You write this

A small suggestion to you to try.

can I send you a private mail containing a very little source code?and a question?


Have a nice day

Marco

These are decisions of your customer I think.
The question is: your application will remain as fast as it currently is?
Do they have good connectivity?

Think about it carefully

Have a nice day
marco

Silvio,
have you some records in which the year of field named "data" is 2024
In the screenshot I see 1971

Bye

Silvio,
what return code do you have?

Some benchmarks using a table opened by other user containing 6000 records indexed in a lan
0.06 seconds using Enrico's technique and 11.57 seconds using a normal DO WHILE !EOF() ; SKIP ; ENDDO cicle

If table is opened only by this test program the speed is the same 0.06 seconds

Thanks Again
marco

simply fantastic Enrico

nageswaragunupudi wrote:This is exactly what I am looking for.
Can we open cdx file alone (raw file) and retrieve a list of record numbers of a specified Tag.
One should know the structure of CDX file very well.

Only great Experts like Mr. Enrico can help us.
And surely that will be a great help to all of us.

Thanks friends
You are all very good. Excellent programmers.
Let's see if I can explain myself
Let's just focus on the customer.cdx file
Let's forget about customer.dbf for a moment

I imagine that for the FIELD -> last key there is written somewhere the number of a record or more records that ...

Very interesting Enrico!

Karinha I want an array containing all record numbers because the real speed of a cycle that
FOR i := 1 TO LEN( aRec )
GOTO aRec[ i , 1 ]
NEXT i

and not by this one that is very slow if cdx is opened by other person

DO WHILE !EOF()
SKIP
ENDDO

But I would hope that ...

Hi to all,
I'm wondering which is the best/fastest way to load an array containing all records numbers in a dbf table indexed by a particular order
Obviously not this one ot this one because as written in my previous post it is very slow if opened by other users.
I don't know how cdx are ...

Michel,

Did you try my sample? It demostrates that there is a problem that is not related with the specific PC or network.

The question of Enrico is This is the question of my post .

Please Michel Try this
#include "Dbinfo.ch"


REQUEST DBFCDX
REQUEST DBFFPT


FUNCTION MAIN()

LOCAL nSec ...