2 replies to this topic

[malindesha]

I have developed Point of sale application using C# 1.1 for busy supermarket,it billed 20-30 bill per min. it work great, it has 5 POS front ends and access 2003 client database in each machine and upload to sql server 2005 back end server after each sales end completely.
but some time system occur two major problem,

1. some time system hold for 1-2 min with not responding and continue to run after waiting with no error. this problem is not occur often, and have not any identical event. some time this occur when item add to list view, some time when changing item values, some time load new form as item search.. ect.

2. shop continuously run 12 hrs each day, all these machine get slow in several hours when continuously run without restart each machine, after restart the systems all are working fine as before.

I use all sql query using store produces, as find item from server database.. update, delete.. generate new invoice no .. ect

please give me some idea to solve this.

thanks!

[BuckAMayzing]

There just isn't any way to answer your question without more information. But if you developed the program, why bother with Access for a client db at all? Wouldn't it be easier to just have the POS to connect directly to the database?

[malindesha]

Thanks BuckAMayzing for reply!

I use acc db for minimize the server trafiic while sales on going.
for not responding problem, i found 2 solution from google
01. use Application.DoEvents(); method
02. use Thread method

i try to use Thread method as following link details
E&K Lab: What to do if your C# app shows messages "not responding" at the top of the window.

but some time it not working correctly with sql query , i try to find googling to multy thread use with data base application but i cannot find well discrib document to solve this matter. and i have no idea where i can use application.doevent method to resolve this problem.

thanks!