11/22/2024 8:51:28 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss using the SalesLogix OLE DB Provider from external applications (including usage of built-in provider procedures). View the code of conduct for posting guidelines.
|
|
|
|
ExcuteReader takes too much time to execute the command.
Posted: 25 Jun 08 7:03 AM
|
Hi,
I m using "ExecuteReader". I have around 1000 records in the address table. when I do "cmd.ExecuteReader()" , it takes around 2 min to execute it. but it doesn't happen every time. sometime result come within a second.
Can any one help me in resolving this issue. this is my code :
string strAddressTableText = "select * from ADDRESS where 1=2";
OleDbCommand cmd = slxDBCon.CreateCommand();
cmd.CommandText = strAddressTableText;
OleDbDataReader reader = cmd.ExecuteReader();
ArrayList addressArray = new ArrayList();
for (int ctr = 0; ctr < reader.FieldCount; ctr++)
{
addressArray.Add(reader.GetName(ctr));
}
Thanks
Ruchi |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|