|
| Best way to deal with large tables |
| Iniciado por PETR_K, 11,oct. 2015 22:25 - No hay respuesta |
| |
| | | |
|
| |
Miembro registrado
71 mensajes |
|
| Publicado el 11,octubre 2015 - 22:25 |
Hi,
please, is somewhere some kind of "tutorial" or webinar regarding how to deal with browsing tables displaying data from SQL DB with many rows?
I have found on PC Soft forum that there should be a seminar by Andy Stapleton regarding this but I can not find it...
I have typical scenario: TABLE on top, edit CONTROLS below table, user fill controls and click on SAVE and I would like to add a row to the TABLE and select this row, all should be fast.
Some points I am trying to solve:
1. Is there any way how to add one row to a table without refreshing the whole table? I mean without loading all the rows again from SQL server? TableAdd() does it but you have to use TableSave() after it, otherwise it does not add next rows.
I tried to use TableDisplay() with all parameters but it is still loading all rows again or it does not allow me to add new row.
2. Some kind of paginating could be handy.
3. I know I can link table to array of objects but I do not know how does it help me and why should I do that.
4. Is 30 000 rows already too much? If yes and I filter table somehow to decrease it, how could user use default search icon in column header? It will work only with filtered rows (?)
Thank you in advance for pointing me in the right direction.
Petr |
| |
| |
| | | |
|
| | | | |
| | |
|