views...

Danny Lewkin daniel.lewkin at cognosis.be
Tue Aug 14 01:53:09 CDT 2007


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

Greetz,

Danny


More information about the Valentina mailing list