views...

[Ivan Smahin]

Hello Danny,

Tuesday, August 14, 2007, 9:53:09 AM, you wrote:

> Hey List, Ruslan,

> I have noticed that running a query on a view takes twice as long  
> than just running the query...
> What I mean is this :

> - create a table_somthing with some fields
> - create a view vw_test As 'select * from tbl_something'

> Now, if you run this query

> - select * from tbl_something

> VStudio results with a time of 0.006 seconds.

> But when you run this query :

> - select * from vw_test

> I get the same records (of course), but the query time is 0.013  
> seconds....

> Is this normal??

We  have  improved  a lot of things in v.3.3, including views. So such
views should be faster now.


-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com