I’m copying a blob field from 1 table to another table.
_rec.blob_file = _blob_rec.blob_data
How does Servoy handle this code in the smart client? Does servoy handle this server side? Or will the data first be loaded clientside to read the source record (_blob_rec.blob_data) and the store it again on the server in _rec.blob_file?
IF the latter is the case, is it possible to do this server side? And if I want to compress this data (IT2BE tools zip function) can this be done server side from within the smart client?
Jos, you do this in the client, so yes (I think) this is done client-side…
This is good example, why you can (must) use the headless-client plugin, in such cases.
than this is done on the server, without the overhead, to download/upload the blob data through the client.
Using a client remotely or locally (on Server) means it the data still has to be send to the client to be able to write it back again. That’s especially for BLOB’s a lot of overhead. If you really want the least amount of overhead use a INSERT (with a SELECT statement) query and it will all be done INSIDE the database.
Of course this requires that the 2 tables are accessible in the same database.
Thanks for the answers, I think the insert solution is the quickest fix for me so I’ll try using that for now.
But the headless client seems to be the best solution if it needs to be compressed.