Page History
...
When a user types a value into a text field (which is bound to a specific column of the database table) and clicks out, the Servoy Application Server issues a SQL update command to the database to modify the selected record. The resulting change is also broadcast|display/DOCS/Data+Broadcasting|||||||||||||||||||||\ to all connected clients.
...
The fundamental unit of data binding in both the GUI and the API is the Servoy Foundset|display/DOCS/Foundsets+Concepts|||||||||||||||||||||\ object.
Client Cache
A Servoy client instance keeps track of which database records are in use. This is called the Client Cache and it optimizes performance by reducing the number of queries made to the database. Records are tracked by primary key. The first time the contents of a record are accessed, the Application Server must issue a query to the database on behalf of the client. The values for all of the columns of the record object are held in memory and therefore, subsequent access of the record will not produce anymore queries to the database. The user experience is greatly enhanced as one can browse quickly between forms and among cached records.
A record may fall out of the cache gracefully to conserve memory and is automatically reloaded the next time it is accessed. This happens at the discretion of the client's caching engine, which is highly optimized. Relieved of the burden of managing memory, the developer can focus on more important things.
...
Tasklist | ||
---|---|---|
| ||
Merge in Relations Page
Merge in ValueLists Page
A section on Programming
Updating the client cache?
Editing Tables from Servoy
http://forum.servoy.com/viewtopic.php?p=85478#p85478
http://forum.servoy.com/viewtopic.php?p=85475#p85475
http://forum.servoy.com/viewtopic.php?p=78242#p78242
http://forum.servoy.com/viewtopic.php?p=78547#p78547
http://forum.servoy.com/viewtopic.php?p=77967#p77967
http://forum.servoy.com/viewtopic.php?f=22&t=11684#p75081
http://forum.servoy.com/viewtopic.php?f=22&t=11684#p75081
http://forum.servoy.com/viewtopic.php?f=13&t=14089#p74182
http://forum.servoy.com/viewtopic.php?f=22&t=14078#p74018
http://forum.servoy.com/viewtopic.php?f=4&t=13931#p73033
http://forum.servoy.com/viewtopic.php?f=22&t=13885#p72762
http://forum.servoy.com/viewtopic.php?f=22&t=13646#p71003
http://forum.servoy.com/viewtopic.php?f=3&t=13280#p68498
http://forum.servoy.com/viewtopic.php?f=3&t=13276#p68496
http://forum.servoy.com/viewtopic.php?f=22&t=13218#p68248
http://forum.servoy.com/viewtopic.php?f=22&t=13171#p67928
http://forum.servoy.com/viewtopic.php?f=8&t=13158#p67832
http://forum.servoy.com/viewtopic.php?p=85817#p85808
http://forum.servoy.com/viewtopic.php?p=85817#p85817
|