T
Trip
Hello again all,
Another question to all of you "in the know".
I would like to speed-up the process of reading updates to a dB. Right
now, between the write of one application and the read of this
application across a [very small 100 mbit] network takes about 2
seconds.
How can I pole a dB to check for new records without closing and
reopening the dB? Is there another way to refresh the dB connection so
that the record-set has the newest record? Or, is this simply a matter
of reducing the size of the record set? Is there ADO functionality I
could use that not in DAO? How do I speed this up?
Here's how I do it now...
Set eScalperDB = OpenDatabase("E:\My Databases\eScalper.mdb", False,
True)
.... (in another module that loops 0.3 seconds)....
Set rstTickDataRead = eScalperDB.OpenRecordset("Select * FROM
Table_Tick_Data WHERE Date_Stamp = #: & Date & "# ORDER BY Date_Stamp,
Time_Stamp", dbOpenDynaset)
eScalperDB.TableDefs.Delete ("Table_Tick_Data")
eScalperDB.Close
...........................
As you can see I am opening and closing the dB connection every time I
pole. I have found that even if I write to the dB (from another
application) and pole the dB (from this application) every one-third of
a second it still takes two seconds for the this application to update.
Any thoughts would be great!
Thanks!!!
Trip
Another question to all of you "in the know".
I would like to speed-up the process of reading updates to a dB. Right
now, between the write of one application and the read of this
application across a [very small 100 mbit] network takes about 2
seconds.
How can I pole a dB to check for new records without closing and
reopening the dB? Is there another way to refresh the dB connection so
that the record-set has the newest record? Or, is this simply a matter
of reducing the size of the record set? Is there ADO functionality I
could use that not in DAO? How do I speed this up?
Here's how I do it now...
Set eScalperDB = OpenDatabase("E:\My Databases\eScalper.mdb", False,
True)
.... (in another module that loops 0.3 seconds)....
Set rstTickDataRead = eScalperDB.OpenRecordset("Select * FROM
Table_Tick_Data WHERE Date_Stamp = #: & Date & "# ORDER BY Date_Stamp,
Time_Stamp", dbOpenDynaset)
eScalperDB.TableDefs.Delete ("Table_Tick_Data")
eScalperDB.Close
...........................
As you can see I am opening and closing the dB connection every time I
pole. I have found that even if I write to the dB (from another
application) and pole the dB (from this application) every one-third of
a second it still takes two seconds for the this application to update.
Any thoughts would be great!
Thanks!!!
Trip