Threads

Hi



I have an app that connects to a database every 15 seconds to gather data
then disconnects. The system is designed to run on a dial-up connection, but
has been mostly developed on a broadband connection.

It has only come to light today that when running on a 56k modem every time
it connects to the database the app slows/freezes and will not take any
keyboard input until it is finished. I have been told that this may be to do
with threads/processor time. I am using a conponet called MySQLDAC from
MicroLab, I have contacted them but they can't send me any example code for
about 2 weeks, trouble I need it now (it's that always the way)

Does any body know how to create a threads so that database connection is on
one thread and the main app runs OK



Best to warn you I'm not 100% sure on what threats are or how they work, I
have had a look round the net for some help but can't seem to find any



Brian


.

Relevant Pages

  • Re: Please Urgent - Update Data Source Problem ???
    ... When the app starts, I'd check to see if the table exists. ... That'd probably be a preferable method to creating the database each time ... If you put connection close ... schedule, and they can update the existing schedule, add new schedule and ...
    (microsoft.public.dotnet.framework.compactframework)
  • ASP.NET data access
    ... We have used ADO datasets previously for a windows application that we developed where the entire db was loaded into the dataset at the beginning of the application and the user made changes to the dataset which was then saved back to the db when the app was shut down. ... Which means that when data is required it is returned from the dataset saving a connection, but has used a heap of resources loading from the db in the first place. ... We would in this case have insert methods which would then use inserts, updates and deletes to directly update the database. ... The problem that this technique seems to have is that you are creating a dataset in each method, which is failur repetitive and may only contain a few rows. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: OleDbConnection does not release Access database
    ... this is not a web app. ... a Microsoft Access database. ... the database connection, but that seems a little excessive for what ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: How to manually check for a DB connection at the Form Load event?
    ... you will not have any connections available to the database yet. ... Each instance of the app requires its own connection. ... > information that will be queried and written to a Data Grid on the Web ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Threads
    ... >I have an app that connects to a database every 15 seconds to gather data ... >has been mostly developed on a broadband connection. ... >with threads/processor time. ...
    (alt.comp.lang.borland-delphi)