Hi, Does anyone know of the fastest way to get the size of a single table row in bytes?
Im currently using the following query: (this query takes 7 seconds which is not efficient). SELECT SUM(LENGTH(CONTACT(view_stat_id,account_id,project_id,contact_id,timestamp)) ) as size FROM table1 WHERE account_id='10043'; THIS IS TO DETERMINE HOW MUCH DISK SPACE THE ROW IS TAKING UP! Any help will be appreciated. Thanks ------------------------------------------------------- Carl Fretwell - Web Developer - Doctor Net t. 0870 770 4990 - f. 0870 770 4991 Visit www.doc-net.com - let us be your key to the web Visit www.eMailCampaigner.com - discover the power of permission based marketing ------------------------------------------------------- The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you received this in error, please contact the sender and delete the material. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
