Valentina Server is both a powerful business reports server for MySQL, PostgreSQL, MS SQL Server and Valentina DB as well as its own object-relational, ultra fast database server. From now until November 1, 2014, save up to $500 on more connections capacity on this enterprise class server – that’s more connects, no added cost! (more…)
Paradigma Software announces that Valentina Release 5.6 is now available for download. If your software license began after October 16, 2013, the update is free. (more…)
- We have table T1 with field String 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.
- Build index for this field.
We have re-write from scratch section about Valentina DB Indexes. You can read it here.
Paradigma Software announces the immediate availability of Valentina Technology Release 5.5.8, a fixes and improvements to Valentina Studio, Valentina Server and the Valentina Kernel (underlying all Valentina products).
You can find a complete list of changes in the Release Notes on the Valentina Wiki.
Taylor Ren over at Sitepoint gives Valentina Studio, Valentina DB and Valentina Reports a look over. His report primarily touches on Valentina Studio (for Linux) but also in context with MySQL. Check it out, and feel free to comment on your experiences – Taylor is very engaging with his readers.
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.
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
There are several database tools available for generating records for table T with some random data. Usually these tools can…
- generate the test data itself;
- format the data for replication of some bug
Yes, both very useful. But as speed junkies and test pilots, we also want to use this feature to
- generate data for use in benchmarks
The difference between test and bench data, is that for benchmarking today, tomorrow and months or years later, we should generate the same records into a Table. Otherwise how we can compare results of a benchmarks as computer scientists? For tests it is okay to use random values in records, but benchmarks require exactness.
We were going to add such feature into Valentina Studio, but then we started thinking about benchmarking the Valentina engine (made in C++). It is clear then that we need such a feature right in the engine. So how to implement it?