Internal optimization for views and sub-queries.

In some cases we can avoid copying sub-query result to the temporary table. We can even use sub-query cursor “as is” – so it could be used as a result of the whole query. In other words there  is almost zero overhead against a simple query.

For now such optimization can be applied if a query:

  1. contains only “*” item in the select list clause
  2. has no “where” clause
  3. has no “group by” clause
  4. has no “having” clause
  5. has no “distinct” clause
  6. is not a part of some join operation
  7. has no “order by” clause
  8. has no binding values
  9. sub-query is not a “union/except/intersect” result

Examples:

SELECT * FROM (SELECT * FROM t1 WHERE f1 > 5);

SELECT * FROM (SELECT t1.f1, t2 f1 FROM t1 JOIN t2 ON l1 WHERE t1.f1 > 5 AND t2.f1 <3);

Two new Video Tutorials about ODBC datasource setup.

We have add 2 news video tutorials EN. One for MAC and one for WIN about how to setup ODBC datasource around Valentina ODBC driver.

http://valentina-db.com/dokuwiki/doku.php?id=valentina:video:video

These lessons can be helpful to setup ODBC data source for other dbs also, e.g. MySQL or MS Access, if you want import from then into Valentina using
Valentina Studio ODBC data import.

And lesson about this import from ODBC is our next lesson, which is in the work.

Valentina for iPhone becomes free for use with release 4.2!

With 4.2 release we make Valentina for iPhone (iV4CC), which currently is VClient only, totally free for download and use. Of course you should have a license of a Valentina Server.

Note, that now you can easy download iV4CC and VServer Office archive with DEMO license, develop and test application on both Simulator and iPhone Device.

Project window have new “Import Local/Remote Project” buttons

These buttons allow you easy import local project to a remote Valentina Server, and visa versa – remote project to local HDD.

Idea is simple: you choose local project, then vstudio create on a selected VSERVER a new project, and execute INSERTs record by record from your local project’s table.  As result, you get on the VSERVER a new project with all the same items, which already registered and ready for use.

Report Editor get powerful formatting by pattern

This is a very important feature for reports. And we have implement it using the same internal engine as the Valentina SQL format() function.

You can read Valentina WIKI: http://valentina-db.com/dokuwiki/doku.php?id=valentina:vcomponents:vsql:reference:expr:funcs_string#format

For any output field you can specify in the inspector its pattern and kind of pattern (number, currency, …).