General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2003 Server
Thanks but that's not the problem. I've always set the second property on SQLSTRINGCONNECT to True, and thanks to Code References, it's easy to check that I didn't miss one. I'm within a week of releasing this application and am becoming very worried that I'm missing some big piece of this puzzle.
Using a string for the CONNSTRING clause of the USE command creates a new connection for each view. it is much slower, but is there a limit to the number of connections that can be created this way? Perhaps I should just accept poor performance.
Using the handle number is 13 times faster when opening multiple views, but results in a Connection Busy message on every view which follows one opened with data. It is as if the command suddenly behaves synchronously.
What am I missing?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only