Application is slow

shadow80 · Post by **shadow80** » Tue 11 Apr 2006 10:37

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?

Challenger · Post by **Challenger** » Tue 11 Apr 2006 11:38

We need more detailed desciption of your problem.

shadow80 · Post by **shadow80** » Tue 11 Apr 2006 11:54

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.

Challenger · Post by **Challenger** » Tue 11 Apr 2006 13:28

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