On Tue, Feb 10, 2009 at 1:47 PM, Steven Buehler wrote:
> From: Jochem van Dieten:
>> What the database will do for you behind the scenes is expand your
>> usage of the view. In effect, the database will replace "x" with its
>> definition. So your query SELECT a FROM x; gets expanded to:
>> SELECT a
> -Original Message-
> From: Jochem van Dieten [mailto:joch...@gmail.com]
> Sent: Tuesday, February 10, 2009 5:10 AM
> To: mysql@lists.mysql.com
> Subject: Re: MySQL View
>
> On Mon, Feb 9, 2009 at 3:41 PM, Steven Buehler wrote:
> > Ok, I just saw a post abou
On Mon, Feb 9, 2009 at 3:41 PM, Steven Buehler wrote:
> Ok, I just saw a post about using view's in mysql. I tried to look it up
> and found how to use it, but my question is: what is a view and why would
> you use it?
The problem with any definition of an object in a database is that
there are m
Steve
From: Claudio Nanni [mailto:claudio.na...@gmail.com]
Sent: Monday, February 09, 2009 3:59 PM
To: Steven Buehler
Cc: mysql@lists.mysql.com
Subject: Re: MySQL View
Steven,
I would suggest you the reading of a basic book about SQL and Databases, I
explain you why.
Views are a very fundam
t; Sent: Monday, February 09, 2009 11:26 AM
> To: Steven Buehler; ba...@xaprb.com
> Cc: mysql@lists.mysql.com
> Subject: RE: MySQL View
>
>
>
> My current understanding of the delta between Views and Temporary Tables
> Views are read only results from 1 or more tables ..in Oracle they
that sound
correct?
Thanks
Steve
From: Martin Gainty [mailto:mgai...@hotmail.com]
Sent: Monday, February 09, 2009 11:26 AM
To: Steven Buehler; ba...@xaprb.com
Cc: mysql@lists.mysql.com
Subject: RE: MySQL View
My current understanding of the delta between Views and Temporary Tables
View
CC: mysql@lists.mysql.com
> Subject: RE: MySQL View
> Date: Mon, 9 Feb 2009 10:10:45 -0600
>
>
>
> > -Original Message-
> > From: baron.schwa...@gmail.com [mailto:baron.schwa...@gmail.com] On
> > Behalf Of Baron Schwartz
> > Sent: Monday, February 09, 2
> -Original Message-
> From: baron.schwa...@gmail.com [mailto:baron.schwa...@gmail.com] On
> Behalf Of Baron Schwartz
> Sent: Monday, February 09, 2009 9:19 AM
> To: Steven Buehler
> Cc: mysql@lists.mysql.com
> Subject: Re: MySQL View
>
> On Mon, Feb 9, 2009
On Mon, Feb 9, 2009 at 9:41 AM, Steven Buehler wrote:
> Ok, I just saw a post about using view's in mysql. I tried to look it up
> and found how to use it, but my question is: what is a view and why would
> you use it? Is it like a temporary table? Does it write a new database to
> the disk or
Ok, I just saw a post about using view's in mysql. I tried to look it up
and found how to use it, but my question is: what is a view and why would
you use it? Is it like a temporary table? Does it write a new database to
the disk or use memory?
Thanks
Steve
Hi!
Daniel Kasak wrote:
[EMAIL PROTECTED] wrote:
Views differ from tables in that they cannot be indexed.
I've just started experimenting with derived tables under 4.1.14, and I
had a hunch this was so. Is there any plan to include index support for
views / derived tables?
An index is a s
[EMAIL PROTECTED] wrote:
Views differ from tables in that they cannot be indexed.
I've just started experimenting with derived tables under 4.1.14, and I
had a hunch this was so. Is there any plan to include index support for
views / derived tables?
--
Daniel Kasak
IT Developer
NUS Consulti
Thanks a lot Shawn.
I didn't realize that views don't take advantage of indexing. This is the
cause of my major performance hits. I'm basically using views as a form of
DB abstraction over the tables. So, many of my views pull all records from
all tables they join, and it is up to the user to s
Scott Klarenbach <[EMAIL PROTECTED]> wrote on 01/06/2006 08:13:10
PM:
> Hello,
>
> I'm new to views and am discovering massive performance hits in the
views
> I've created once the records start to climb above 20,000 or so. Does
> anyone know of a great primer/tutorial site for optimizing view
Hello,
I'm new to views and am discovering massive performance hits in the views
I've created once the records start to climb above 20,000 or so. Does
anyone know of a great primer/tutorial site for optimizing views in MySQL,
or even generally? What are the best practices etc...? I find when I
Hi there,
Does anyone know how views are implemented in MySQL? Is the view query
executed each time the view is interacted with (ie. query modification) or
is there some sort of caching involved (i.e. view materialization).
thanks
_
16 matches
Mail list logo