Category: Valentina KERNEL

Valentina 5.7.5 Released: Updates for Kernel, Server and Examples

Valentina 5.7.5
Paradigma Software announces Valentina 5.7.5 updates are released, with improvements for the Valentina Kernel, Valentina Server and improved examples for Valentina ADK for Xojo. Continue reading Valentina 5.7.5 Released: Updates for Kernel, Server and Examples

Valentina 5.7 Delivers Access Control for Valentina Server

Valentina 5.7 Released

Valentina Technology Release 5.7 products, including Valentina Server 5.7 and Valentina Studio Pro 5.7 are now available for download from the Paradigma Software website. Continue reading Valentina 5.7 Delivers Access Control for Valentina Server

v5.6 Builds Index of String/VarChar field in 10-15 times faster!

Bench Description

Prepare Steps

  • We have table T1 with field String[120] or VarChar.
  • We add 1 million records with unique values using METHOD( ‘concat( rand_string(80), RecID’ ) ) 

 So we get table with one only field, 1 millions records, values are about 80-90 chars length.

Benches

  • Build index for this field.

Continue reading v5.6 Builds Index of String/VarChar field in 10-15 times faster!

[NEW] Generating Test/Bench Data for Data Focused Apps (Part 2)

We have implement Stored Procedure ‘GenerateDataFor()’, which solves the task described in the part1 of this article.

We have added into Valentina Wiki new section, where we will keep this and future other Stored Procedures By Paradigma Software.

On this page you can find link to WIKI page, which describes GenerateDataFor() procedure and contains download link.

[NEW] SQL expression function RAND_REGEXP()

We added a new SQL function RAND_REGEXP  into v5.5.6 (available in the night_build or upcoming beta). This is very powerful function that can generate random strings of any kind, following some regular expression.

This function is useful for test and bench data generation features we will be talking more about.

Our wiki has coverage of this new function: RAND_REGEXP