颍川151
2012-05-04, 23:34
最近我在导入数据库时出现了问题,就是我想求出这数据的平均值,不过那数据有6G,希望有大虾解救,万分感谢!!!
function xx()
timeoutB1=logintimeout(5);
connB1=database('call_one','','');
setdbprefs('DataReturnFormat','numeric'); %设置数据返回格式的优先权值,返回为数值型
setdbprefs('ErrorHandling','report'); %设置数据错误处理优先权值
cursorB1=exec(connB1,'select 字段12 from Tb_call_201202_1');
cursorB1=fetch(cursorB1);
B1=cursorB1.Data;
close(cursorB1)
close(connB1)
avg2=mean(B1(:,1))
这是出现错误:
??? Java exception occurred:
java.lang.OutOfMemoryError: Java heap space
然后我再这样弄:
function xx()
timeoutB1=logintimeout(5);
connB1=database('call_one','','');
setdbprefs('DataReturnFormat','numeric'); %设置数据返回格式的优先权值,返回为数值型
setdbprefs('ErrorHandling','report'); %设置数据错误处理优先权值
cursorB1=exec(connB1,'select 字段12 from Tb_call_201202_1');
fetchsize = 10000;
% Check for more data. Retrieve and display all data.
while ~strcmp(cursorB1.Data, 'No Data')
cursorB1=fetch(cursorB1,fetchsize);
B1=cursorB1.Data(:);
end
close(cursorB1)
close(connB1)
avg2=mean(B1(:,1));
然后出现的错误是:
??? Undefined function or method 'sum' for input arguments of type 'cell'.
Error in ==> mean at 28
y = sum(x)/size(x,dim);
Error in ==> xx at 15
avg2=mean(B1(:,1));
求版主解答
function xx()
timeoutB1=logintimeout(5);
connB1=database('call_one','','');
setdbprefs('DataReturnFormat','numeric'); %设置数据返回格式的优先权值,返回为数值型
setdbprefs('ErrorHandling','report'); %设置数据错误处理优先权值
cursorB1=exec(connB1,'select 字段12 from Tb_call_201202_1');
cursorB1=fetch(cursorB1);
B1=cursorB1.Data;
close(cursorB1)
close(connB1)
avg2=mean(B1(:,1))
这是出现错误:
??? Java exception occurred:
java.lang.OutOfMemoryError: Java heap space
然后我再这样弄:
function xx()
timeoutB1=logintimeout(5);
connB1=database('call_one','','');
setdbprefs('DataReturnFormat','numeric'); %设置数据返回格式的优先权值,返回为数值型
setdbprefs('ErrorHandling','report'); %设置数据错误处理优先权值
cursorB1=exec(connB1,'select 字段12 from Tb_call_201202_1');
fetchsize = 10000;
% Check for more data. Retrieve and display all data.
while ~strcmp(cursorB1.Data, 'No Data')
cursorB1=fetch(cursorB1,fetchsize);
B1=cursorB1.Data(:);
end
close(cursorB1)
close(connB1)
avg2=mean(B1(:,1));
然后出现的错误是:
??? Undefined function or method 'sum' for input arguments of type 'cell'.
Error in ==> mean at 28
y = sum(x)/size(x,dim);
Error in ==> xx at 15
avg2=mean(B1(:,1));
求版主解答