|
-
Mar 18th, 2009, 04:32 AM
#1
Thread Starter
Frenzied Member
Database Update Very Slow due to many rows???
Hi Peeps,
I have a auditing program which is run on a PDA with WM5. It records data in several tables and the data is output as XML files and sent via mobile to a FTP server. One of my tables has 17000 rows in it now and when I run my recovery routine it takes 4 seconds to do the database update routine for every row. My recovery program un tags rows with a specified audit date.
Is there any reason why this should occur or is there a better way of updating the live database?
Cheers,
Jiggy!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|