Devart Forums

Hello!

I've ran into the following problem:

When dealing with larger resultsets, if the charset is set to UNICODE_FSS the performance of IBDAC slows down drastically.

IE.: 10.000 records are loaded in about 3-4 secs with the UTF8 charset.
With the same settings if charset is set to UNICODE_FSS it takes IBDAC almost 40 seconds to load the same number of records on the same computer.

Initially, I was using UTF8 for connecting in my program. But IBDAC version 3.50.0.19 released 08-Dec-10 introduced the following fix:
"Now the UTF8 charset is used instead of UNICODE_FSS, when TIBCConnectionOptions.UseUnicode is True and Charset is set to 'UTF8'"

Since then, without setting the charset to UNICODE_FSS I was experiencing various problems in my program.

My question is: is this a bug in IBDAC and is there a workaround without setting the charset to UTF8?

Thanks!

Hello,

Unfortunately I cannot reproduce the problem.
Please specify the following:
- the type (Interbase/Firebird) and the exact version of the database server and the client you are working with. You can learn it from the Info sheet of TIBCConnection Editor;
- a script to create your database and the table;
- the exact version of IBDAC you are using. You can learn it from the About sheet of TIBCConnection Editor;
- the exact version of your IDE.