natarius Posted January 24, 2006 Posted January 24, 2006 hi, i have some problems with my msde/sql express database located on an inet server (p4 2,4ghz, 1024mb ram, 100mbit broadband connection). i have about 10 clients out there which connect every 15 minutes do the db to do some processing...mostly performing select commands which seems to run fine! i have one admin tool to fill the db with records here at my office and sometimes when i am performing an update or insert command it just timeouts...i then have no chance to edit records! just a few records seem to be blocked, because some work like always!! sometimes after a few minutes everthing is ok again...sometimes it takes hours what is causing this? pleas help greets matthias Quote
Puiu Posted January 26, 2006 Posted January 26, 2006 Maybe it could be that the other users update the same rows at the same time as you. Did you try to update or insert when you were sure that nobody was connected ? Quote
natarius Posted January 26, 2006 Author Posted January 26, 2006 no, its only me trying to update/delete the rows! Quote
natarius Posted January 29, 2006 Author Posted January 29, 2006 seems like i found the solution: i added a timestamp row to every table, now it works! Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.