Getting Result Set Size

[Mike Patrick]

I have been trying to calculate the size in bytes of a result set. This is based on the bandwidth calculation example. It seems to work at first and then eventually, the row values become nil. It seems to be also at a random number of rows even if I re-run it with the exact same data. Any help would be GREATLY appreciated!

BTW, I added a row count to be sure it was going through all of the rows and it is.

Below is the code I am using:

local bandwidth = 0

function read_query (packet )
bandwidth = bandwidth + string.len(packet)
proxy.queries:append(1, packet)
return proxy.PROXY_SEND_QUERY
end

function read_query_result(inj)
local rows = inj.resultset.rows
local fields = inj.resultset.fields
local rowcount = 0
local numcols = #inj.resultset.fields

if fields then
for i = 1, #fields do
bandwidth = bandwidth + (fields and fields.name:len() or 0)
end

if rows then
for row in inj.resultset.rows do
rowcount = rowcount + 1

for i = 1, numcols do
print (row)
bandwidth = bandwidth + (row and row:len() or 0)
end
end
end
print ("Row Count: " .. rowcount)
print ("Bandwidth:" .. bandwidth)
end
end

Thanks,
Mike