You are here: Re: Getting data from multiple rows into one column « MsSQL Server « IT news, forums, messages
Re: Getting data from multiple rows into one column

Posted by Alexander Kuznetsov on 12/04/05 19:25

> The most basic rule of a tiered architecture?

The most basic rule of business is making money. Soemtimes it is way
cheaper to implement formatting just once in the database, as opposed
to doing it in VB, Crystal report, ASP, ASP.Net, whatever else.

Also note that data is transferred to the client in packets. So the
difference between sending over the network 1 packet:

Smith, John 1,3,5,7,17

and sending over the network 2 or more packets:

Smith, John 1
Smith, John 3
Smith, John 5
Smith, John 7
Smith, John 17

is at least 100% drop in performance.

 

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

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