Page 1 of 1
Application is slow
Posted: Tue 11 Apr 2006 10:37
by shadow80
Sorry for my English...
I use dbExpress driver for Oracle 9i and MSSQL.
When I started application on MSSQL all is OK, but on Oracle is very slow.
Why? What do I wrong?
Posted: Tue 11 Apr 2006 11:38
by Challenger
We need more detailed desciption of your problem.
Posted: Tue 11 Apr 2006 11:54
by shadow80
object SQLConnection1: TSQLConnection
ConnectionName = 'OraEarhiva'
DriverName = 'Oracle'
GetDriverFunc = 'getSQLDriverORACLE'
LibraryName = 'dbexpora.dll'
LoginPrompt = False
Params.Strings = (
'DriverName=Oracle'
'DataBase=xx'
'User_Name=shadow'
'Password=xxxx'
'BlobSize=-1'
'ErrorResourceFile='
'LocaleCode=0000'
'Oracle TransIsolation=ReadCommited'
'RowsetSize=20'
'OS Authentication=False'
'Multiple Transaction=False'
'Trim Char=False')
VendorLib = 'oci.dll'
AfterConnect = SQLConnection1AfterConnect
Connected = True
*******************************************
procedure TDataModule1.SQLConnection1AfterConnect(Sender: TObject);
begin
if SQLConnection1.VendorLib='oci.dll' then
SQLConnection1.Execute('alter session set NLS_NUMERIC_CHARACTERS=".," ',nil,nil)
end;
*******************************************
I use SQLDataSet,DataSetProvider and ClientDataSet.
Posted: Tue 11 Apr 2006 13:28
by Challenger
We don't support standard Oralce driver dbexpora.dll.
We support Core Lab dbExpress driver for Oracle, which is available at the following page:
http://www.crlab.com/dbx/download.html