Starting from v.5.0, you may get count of affected links (pair of records affected by LINK/UNLINK… statement) via QueryResult::get_AsULong()
Author: Ivan Smahin
New WIKI Article: “DISTINCTROW in Valentina SQL”
New FAQ added
Choosing appropriate database’s segment size
Each Valentina’s volume consists of set of segments, even internal service-data placed in such segments.
Database storage is implemented similar to some file system. There are volumes (.vdb, .dat, .blb, .ind, .tmp) and there are some embedded files on that volumes (all the data like field-data, indexes and so on go to that files). Each volume operates with own segment map – so we can find (and allocate new) segments for particular embedded file easy and fast.
Continue reading Choosing appropriate database’s segment size
Index search warnings
There are many find-like methods which are able to employ indexes to speed up the searching (FindLike, FindRegEx, FindContains, and so on). Of course, the field must be indexed and search preference is set to kPreferIndexed.
But currently there are two issues when index search may bring a wrong result:
1.Index keeps only first 256 symbols of the value – so rest of the symbols are just ignored in such a search.
2. Index-By-Words index and multi-word searching pattern.
Some of the methods like FindRegEx don’t use an index-search but scan the table instead if any of the above occurred. The rest of the methods are less strict choosing the searching algorithm. Now you will get the warning in such cases and you can switch algorithm to not-index search (kPreferNotIndexed) if it is relevant (less speedy but more accurate). Also you should consider to change index type of such a lengthly fields to the index-by-words.
Warning examples:
“Index search in the first 256 symbols only : FindContains t1:f1”
“Index-By-Words search : FindContains t1:f1”
V4NET and SQL-Binding of Pictures.
Starting from 4.8 build you may pass pictures as a binded value to the queries using V4NET ADK.
IOEncoding usage in V4REV
Assume there is some “not-latin” text (it could be russian or umlauts or something similar). And we have to store it to the Valentina database and then read it back.
New LogFilesLocation property
There is a new property – LogFilesLocation for both server and local.
It defines a folder where the logs should be placed in.
Default folder is “./vlogs”
vClient becomes thread-safe (!)
Now you should not synch vClient API calls – vClient do it self and you are free to access and operates with vClient’s remote objects from different threads similiangly.
In particular, vStudio operates with remote connections via multiple threads and it was a source of some glitches and unexpected errors especially with a long queries. Now there are no more errors like “EOF reached…” or “Broken packet received…” which were result of incorrect thread synch.
Altering ObjectPtr
ObjectPtr field contains RecID values of some “target” table. If you need to change ObjectPtr in order to point another table those values are not valid anymore – so default behavior is to nullify them. But sometime it looks to be too strong. For instance – changing field or link name or on-delete policy should not cause such data zeroing.
There are two ways to keep existed values altering ObjectPtr:
- There is a global property – OnChangeTypeZeroPtr. It is set to true by default. But you may change it with following statement – “SET PROPERTY OnChangeTypeZeroPtr TO false”. After this altering ObjectPtr will prevent zeroing data (sure it will be nulls for records which are absent in the new target table). This property is not “schema-storable” – so you should set it up on each run if you need it.
- The first approach is a global setting – so you will be able to keep some ObjectPtr values even changing “target” table. So we implement one more way – much more simple because the only thing you should keep in your mind is – the values will be preserved until you touch “target table” ObjectPtr property (because all values will be valid for the same target anyway).