homepage Welcome to WebmasterWorld Guest from 54.198.224.121
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
mysql views
Sandro87




msg:4105705
 1:21 pm on Mar 27, 2010 (gmt 0)

Hello,
I really don't understand the usage and advantages of VIEWS.

I mean, as I got it, the views are non-indexed temp table that are dropped after the PHP script ends. Then what is the advantage of using it?

 

syber




msg:4105720
 2:54 pm on Mar 27, 2010 (gmt 0)

VIEWS are not temp tables, they are stored SELECT statements. Think of them as virtual tables.

When you reference a view, the stored select statement is executed. Views allow you to create complex queries that you can treat as a table. The underlying data remains in the tables referenced in the view definition. Indexes for those tables are still utilized.

Sandro87




msg:4106407
 2:41 pm on Mar 29, 2010 (gmt 0)

what happens if 2 users run the same script at the same time? The view will be overwritten?

syber




msg:4106975
 2:08 pm on Mar 30, 2010 (gmt 0)

The view does not store any data. The two users see the same result set as if they had typed in the query directly.

bizminder




msg:4111271
 9:19 am on Apr 7, 2010 (gmt 0)

However with exclusive locks two users will never be able to run the same script simultaneously.

syber




msg:4111305
 10:57 am on Apr 7, 2010 (gmt 0)

SELECT statements don't acquire exclusive locks.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About
© Webmaster World 1996-2014 all rights reserved