mORMot Open Source

squirrel

Member

Registered: 2015-08-13

Posts: 155

Sql Query on Virtual Tables

Is it possible to run a sql query on a virtual table?
for example

Select A, max(B) myCustomMaxFieldname from VirtualTable4 group by A order by myCustomMaxFieldname desc

Last edited by squirrel (2017-03-13 12:36:01)

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,655

Website

Re: Sql Query on Virtual Tables

Yes, if there is a real SQlite3 virtual table behind the scene.

But performance won't be somewhat slow, since all data rows will have to be retrieved from the virtual table handler, then processed in the SQLite3 engine.
If you have a virtual table pointing to an external database, you should rather direct such such SQL requests on the external database, by-passing the SQlite3 engine.

See https://synopse.info/files/html/Synopse … ml#TITL_20