Question Pls Help Me!! What's wrong with my program?

[capedech]

Hi all, nice to meet u. I'm new here.
I need help to fix my program.

My Computer : Intel Pentium 4 1,7g, memory 512mb
Using : VB.Net 2005
Database: MySQL

My project is Pharmacy's Application.

Everytime I call this query :
SELECT A.ItemCode, A.ItemName, B.Kemasan, C.SupplierName, E.PabrikName
FROM M_Items A, d_ItemsKemasan B, M_Supplier C, d_ItemSupplier D,
M_Pabrik E, d_ItemPabrik F
WHERE A.ItemCode = B.ItemCode, A.ItemCode = D.ItemCode,
A.ItemCode = F.ItemCode, C.SupplierCode = D.SupplierCode,
E.PabrikCode = F.PabrikCode
ORDER BY A.ItemCode, C.SupplierName, E.PabrikName

SQL result about 500 rows.

Everytime I call that query, the program become slower and slower.
1st try, not to slow.
2nd try, slower.
3th try, very very slow.
4th try, Error -> Fatal Error.

After that, I just can't call that query anymore. Always Fatal Error.

I put that query result at temporary table -> DataSet.

I really don't know what's wrong with it.
I tried to clear the DataSet everytime I put new query result, but It didn't do anything. Still Fatal Error.

Sometimes restarting computer can fix the problem, but most of the times still Fatal Error.

Please Help me.
Do I need to put my coding as well ?


Thanks for the answers.

nb. Sorry my english not so good.

 

[MattP]

We'll need to see your code to determine where the problem is.

 

[cjard]

And what does it behave like when you run it in a MySQL query window?

 

[Bernie]

I would suspect something isn't getting closed correctly or your using to many connection objects. Post some code and let's see what we can find.

Bernie