speed on query in valentina

[Ruslan Zasukhin]

On 06/28/12 9:00 AM, "Ruslan Zasukhin" <sunshine at public.kherson.ua> wrote:

> 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 ???
 
Btw, for such tables with a lots of fields, and db with 150 tables,
It is recommended set big cache.

Try set cache e.g. 50MB in the Valentina_Init()



-- 
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]