hye guys..
rite now i'm apply bayesian algo to my dataset.
the problem is there is about 20 arrays (i declare as obejct)
and i'm gonna loop it for 32562 of data..
is work well when i step tru...but after that my pc shutdown.is this course of the overload? because it always happen when i run the code,,
this is sample of the code:
SQLstring = "SELECT age, education,occupation, hours_per_week, workclass, relationship, race, sex, " & _
"capital_gain, capital_loss, native_country, class " & _
"FROM adult_training "

DMQuery(SQLstring)
'Reply_All = Reply
rowNo = Reply(0, 0)

If rowNo <> 0 Then
For i = 1 To rowNo
'*************************
'count prob given class >50
************************
For a = 1 To rowNo_Age_Y
If Reply(i, 0) = reply_Age_Y(a, 0) Then
PY_Age = Val(reply_Age_Y(a, 1))
End If
Next a

For e = 1 To rowNo_Edu_Y
If Reply(i, 1) = reply_Edu_Y(e, 0) Then
'PY_Edu = y_edu(e)
PY_Edu = Val(reply_Edu_Y(e, 1))
End If
Next e
............

i dont know how to reduce the array because it give different value.how to minise it? or reuse it??