how to count size of table records

Radiant Software

hii...

i have an mysql database. In that db, one table saves records of many members. Now,in asp.net... if insert any member id, I want to know to count total size used by that user. Is it possible???How???

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amitesh Verma11y ago
http://www.sqlmatters.com/Articles/Listing%20all%20tables%20in%20a%20database%20and%20their%20row%20counts%20and%20sizes.aspx

CREATE TABLE #RowCountsAndSizes (TableName NVARCHAR(128),rows CHAR(11),
reserved VARCHAR(18),data VARCHAR(18),index_size VARCHAR(18),
unused VARCHAR(18))

EXEC sp_MSForEachTable 'INSERT INTO #RowCountsAndSizes EXEC sp_spaceused ''?'' '

SELECT TableName,CONVERT(bigint,rows) AS NumberOfRows,
CONVERT(bigint,left(reserved,len(reserved)-3)) AS SizeinKB
FROM #RowCountsAndSizes
ORDER BY NumberOfRows DESC,SizeinKB DESC,TableName

DROP TABLE #RowCountsAndSizes
Radiant Software11y ago
hi Roshan Patil....
I want to count size of row on disk from database.
can u help me???
Roshan Patil11y ago
select count(*) from member_table where member_id=123

this will give all records for member_id=123 in member_table