speed on query in valentina

[Ruslan Zasukhin]

On 06/28/12 4:42 AM, "Robert Mann" <robmann at gp-racing.com> wrote:

> I set up a valentina database which only had one table in to figure out how
> to connect and get data from it, got that working then I created my complete
> mysql database in valentina which has 150 plus tables with some tables
> having several hundred records in them and several hundred columns,

Several hundreds records (this is near to zero)
    or several Hundreds of thousands records ?

Hmm, Valentina do not like tables with a lots of fields.
Although still depend on type of your queries.

If you will touch in SELECT  only few of them from few hundreds, then
Valentina will win a lots. Because Valentina store EACH field into separate
logical file. 

So if e.g. The whole Table takes 1Gb on disk and have 300 fields,
Then touch of 3 fields for Valentina can touch only 3MB

> I thought valentina was suppose to be faster that mysql, in my mysql rev
> application I to not see any delay in the displaying of the sql queries

You mean that Valentina have delay for you?

Then please describe what exactly query you do?
Do you display all 300 fields of the table ???


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]