| View previous topic :: View next topic |
| Author |
Message |
Donald S. Bossen
Guest
|
 Posted: Tue Apr 24, 2007 9:24 pm Post subject: Time Delay in opening a Table |
 |
|
I am working with Delphi6 and an Activant Database in Sql2005 I can conect
with ease and good speed to the data base but when I call open the delay can
be 3 min +.I am also connecting to my own table in a diferent data base on
the server and the open is fast. Once open there is no real time lags. The
activant table I am opening in read only and only need it for Qualifing the
Customer number.
Thanks
Donald S. Bossen |
|
| Back to top |
|
 |
Bill Todd
Guest
|
| Posted: Tue Apr 24, 2007 11:40 pm Post subject: Re: Time Delay in opening a Table |
|
|
Donald S. Bossen wrote:
| Quote: | I am working with Delphi6 and an Activant Database in Sql2005 I can
conect with ease and good speed to the data base but when I call open
the delay can be 3 min +.I am also connecting to my own table in a
diferent data base on the server and the open is fast. Once open
there is no real time lags. The activant table I am opening in read
only and only need it for Qualifing the Customer number. Thanks
Donald S. Bossen
|
What do you mean by "an Activant database in SQL 2005"? What ADO
dataset component are you using? What is the SQL SELECT statment that
you are executing?
--
Bill Todd (TeamB) |
|
| Back to top |
|
|
Donald S. Bossen
Guest
|
| Posted: Fri Apr 27, 2007 12:03 am Post subject: Re: Time Delay in opening a Table |
|
|
Thanks for your responce
Activant is a Software developer. That has a database in Sql Server 2005.I
am using an AdoConnection, an ADOTable, and a DataSource. I am sending no
SQL SELECT that I am aware of I am calling ADOTable2.Open. This is where the
app hangs for several minuets. I have an other table open in the same server
but different database and when I call ADOTable1.Open there is no hangtime.
If I call ADOConnection2.Connected := True there is no delay.
Donald S. Bossen
"Bill Todd" <no (AT) no (DOT) com> wrote in message
news:462e4f31 (AT) newsgroups (DOT) borland.com...
| Quote: | Donald S. Bossen wrote:
I am working with Delphi6 and an Activant Database in Sql2005 I can
conect with ease and good speed to the data base but when I call open
the delay can be 3 min +.I am also connecting to my own table in a
diferent data base on the server and the open is fast. Once open
there is no real time lags. The activant table I am opening in read
only and only need it for Qualifing the Customer number. Thanks
Donald S. Bossen
What do you mean by "an Activant database in SQL 2005"? What ADO
dataset component are you using? What is the SQL SELECT statment that
you are executing?
--
Bill Todd (TeamB) |
|
|
| Back to top |
|
|
Bill Todd
Guest
|
| Posted: Fri Apr 27, 2007 12:23 am Post subject: Re: Time Delay in opening a Table |
|
|
Donald S. Bossen wrote:
| Quote: | Activant is a Software developer. That has a database in Sql Server
2005.I am using an AdoConnection, an ADOTable, and a DataSource. I am
sending no SQL SELECT that I am aware of I am calling ADOTable2.Open.
This is where the app hangs for several minuets. I have an other
table open in the same server but different database and when I call
ADOTable1.Open there is no hangtime. If I call
ADOConnection2.Connected := True there is no delay.
|
I suspect the table that is slow to open has a lot of records. You
should not use TADOTable for anything. Use TADODataSet or TADOCommand.
TADOTable, TADOQuery and TADOStored proc are provided to make it easy
to convert an existing application from the old Borland Database Engine
(BDE) to ADO. The problem with TADOTable is that when you open the
table it selects all of the records in tha table. This is very slow for
a table with many records.
--
Bill Todd (TeamB) |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
