Hi, ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "Nitin" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, October 13, 2003 5:52 AM Subject: Re: Views in MYSQL
<much cut> > What about when the script uses persistent connections, these Temp Tables > would never go away and each new connection create a new Temp Table. > Therefore if you are operating a heavy load web site, the chances are you > could easily run out of disk space. Temp Tables are not a substitute for > Views and were never meant to be. Temp tables are not views, however with persistant connections if the same name for the temporary table is reused (which it should be as temporary tables are unique to each connection even if they have the same name) you will never run out of space. Also persistent connections are not "permanent" connections and they will recycle according to the child rules for apache. > The people at MySQL are more concerned > about speed than they are about standards compilence. Therefore, any feature > which protentially has an affect on performance will not get implemented. A > perfect example of this is Referential Integrity Mysql has referential integrity see: http://www.mysql.com/doc/en/ANSI_diff_Foreign_Keys.html and www.innodb.com or www.sleepycat.com (BDB table types). MySQL AB is concerned about implementing features in a manner that does not adversely affect the users that don't need or want that feature. They do not force everyone to take a performance hit so a new ferature can be implemented quickly. This works well for most MySQL users. If it does not they usually migrate to a more fully featured DBMS such as DB2, Oracle or MSSQL. Regards, Ken > > Regards > Minky > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
