I am writing a vb6 application to take in SMS text messages from a modem, do some string maniplation on the messages and store them in a MySQL database. It also prints them to the main screen of the application.
I am using a timer to check the SIM card for new text messages. If it finds new messages it sorts them into a database and prints them in a listbox on the main screen, then it deletes that message from the SIM card. That is the general runnung of the application
My question is, why does it cause my application to hang after a certain length of time. I have to do a lot of calls to the mysql database for checking strings against fields int the database and inserting and deleting records from the db. My suspicions are that these multiple calls to the db could be a factor for hanging the app.
Also The machine only has 64MB of RAM, a Pentium 4 Processor and is running WinXP.
If anyone has any ideas of why it might be hanging I would appreciate your support