Skip to Content.
Sympa Menu

internetworkers - Re: [internetworkers] SQL Help?

internetworkers AT lists.ibiblio.org

Subject: Internetworkers: http://www.ibiblio.org/internetworkers/

List archive

Chronological Thread  
  • From: Scott Russell <catfather AT donpoo.net>
  • To: "Internetworkers: http://www.ibiblio.org/internetworkers/" <internetworkers AT lists.ibiblio.org>
  • Subject: Re: [internetworkers] SQL Help?
  • Date: Mon, 25 Feb 2008 18:47:12 -0500


On Mon, 2008-02-25 at 16:41 -0500, Ilan Volow wrote:
> I'm a PostgreSQL guy, so take my educated guess with a grain of salt,
> but you might want to try this just to see if it works:

Much appreciated. I'll take a look at it...

>
> If you haven't already thought about it, this kind of statement might
> be a good candidate for a database view.

I'm starting to consider that. I haven't used views before but from what
I can tell they're basically a new table description with pointers back
to an existing table(s).

I'm afraid though that there might be a limitation in MySQL 5.0 with
views and SUM(). The word on the street is that any kind of functions
inside your MySQL 5.0 view is a performance killer.

Of course, this doesn't apply to other DBs

--
Scott <catfather AT donpoo.net>
AIM: BlueCame1





Archive powered by MHonArc 2.6.24.

Top of Page