You are here: Re: mysql query « All PHP « IT news, forums, messages
Re: mysql query

Posted by Stefan Rybacki on 10/02/48 11:32

Rik wrote:
> Stefan Rybacki wrote:
>...
> Could be done, but keeping calculated fields permanent in your db is (most
> of the time) bad db-building and/or a waste of space.

No it isn't. This is what views are made for.

> I'm curious why you'd
> want to have this calculated field in your db in the first place?

An example for "permanent" (in a view) is for example a price and the discount on it.
Views can really speed up things and also keep your data consistent.

Regards
Stefan

>
> Grtz,
>
> Rik
>
>

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация