App Builder IDE

[zehnernet]

Hello!

I have a few questions about the App Builder IDE. So NOT for apps that will be created with it, but directly to the work environment:

- Is there a status bar somewhere, similar to Foxpro?
- Is there a kind of progress bar that shows when I am performing table operations (e.g. indexing) in the console or in a script?
I am currently indexing a field, a very simple index on a table with 3.5 million records from a script. I have issued a WAIT WINDOW. But I don't see how far "he" is. My screen has been standing for
more than 30 minutes now and I don't know if it's stuck somewhere, if things are going well or whatever is going on ...

[josipradnik]

I am not sure but try IOSTATS: https://www.lianja.com/doc/index.php/IOSTATS()

[zehnernet]

I am not sure but try IOSTATS: https://www.lianja.com/doc/index.php/IOSTATS()

Is at least interesting to research how long something takes to adapt the code accordingly. But it only provides information after something has been completed, for example after the index has been created, not while it is being created.

[barrymavin]

No, as with most database systems there is no feedback on the screen until the indexing completes.

You do not say how big the field is or how large the records are.

We have customers with much larger tables than that so it is not uncommon.

If you are indexing a huge table you should SET ICACHE accordingly. You can search for icache here in the forums.

[zehnernet]

That sounds good, I'll start reading ...

Regarding the question of size etc .:
3.5 million records
1 record has 27 fields and is 337 bytes long.
The field to be indexed is Char (50)

[zehnernet]

WOW! What a result:
With the above information on the table and the index ...

Without SET ICACHE: Well over 30 minutes

With

nsize = icache(process_id)
set icache to nsize

only 5 (five) minutes.

That I call real performance!

Thank you very much, barrymavin!

[pauln]

Something tells me I need to bookmark that result
Thanks for sharing Stefan