Today one of user have asked if Valentina supports partial index. Answer is YES OF COURSE, you can easy create a partial index using Table Methods.
Category: Valentina Server
[NEW][API] Valentina.CopyCursorToNewTable()
We introduce a new utility method Valentina.CopyCursorToNewTable(), which is able to save you hundreds of lines of advanced code in your ADK-based applications. This method added into major Valentina ADKs.
You can read detailed description of this new method here.
NEW TIP about Reindex Event to Improve Performance
Index fragmentation can cause problems with query performance. Indexes therefore need to be occasionally rebuilt. Read the full article in the “Valentina Performance Guide” document.
VServer now uses the name of executable as primary instead of ini file
PROBLEM IS:
Up to now (v4.7), a VServer on start searches for INI file in the own directory. Algorithm expects that only one INI file exists in the folder. And if few INI files present, then the first by alphabet is used.
Continue reading VServer now uses the name of executable as primary instead of ini file
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.
NEW Tab-Panels in SQL Editor to Display Logs/Output/Warnings/Tune
We have added to SQL Editor of Valentina Studio great new feature: now you can get much more rich output from an SQL command. And this output is separated into 4 tab panels at bottom of Editor.
Continue reading NEW Tab-Panels in SQL Editor to Display Logs/Output/Warnings/Tune
Working with big vDatabases
Valentina is a perfect choice to work with a big data. It employs vertical storage approach. It means – each column has own virtual file to be stored in. Most of db vendors use a horizontal storage – it stores a table data in record-by-record manner.
There are some vertical storage advantages:
Valentina Server 64-bit.
We are happy to introduce, in the release 4.5, the result of our 8 months efforts – Valentina Server 64 bit for 3 platforms (win, mac, linux)!
SNMP and Valentina Server
There is a new feature in Valentina Server – SNMP agent.
Currently we support only get() and get_next() SNMP requests for the following oids:
sysDescr(“1.3.6.1.2.1.1.1.0” )
sysUpTime(“1.3.6.1.2.1.1.3.0” )
Not much info but it makes a possibility to monitor vServer over SNMP.
For now, SNMP facilities are available only for Windows.
You should specify SNMP port in the server ini-file (default port is 161, 0 means turn off SNMP agent):
…
[SNMP]
Port_SNMP=161; SNMP port to listen by VServer.
; 0 – do not use a SNMP port.
…
Valentina Server Log – Added SysLog Format
You may set LogToSysLog variable to 1 (in the INI file or via vServer properties) to make vServer put log messages into the system log:
* Event log for Windows
* SysLog for Linux.
The default state of variable is off.
Improved AppleScripts on MAC to start/stop VServer.
Now scripts show dialog to ask for ADMIN password, and execute load/unload of a VSERVER under SUDO.
FIXED Snow Leopard issue in VSERVR’s Sheduler.
Thorsten have found that on Snow Leopard VServer crashes if scheduler is enabled.
Problem was in ICU ucal_open() method. It looks that something was changed in the ICU used by 10.6. Now they require 3d parameter LocalName.
FIXED.
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.