Subject | Re: [Firebird-Java] How to change forced writes settings via JayBird? |
---|---|
Author | Alec Swan |
Post date | 2009-10-12T20:08:11Z |
Thanks for the answer and a little sarcasm, Roman :)
The last line in the following code throws "GDS Exception. 335544792. Cannot
attach to services manager".
// start embedded Firebird server
FBManager manager = new FBManager("EMBEDDED");
manager.start();
MaintenanceManager maintenanceManager = new
FBMaintenanceManager("EMBEDDED");
maintenanceManager.setDatabase(getDatabaseFile().getAbsolutePath());
Is there a document which explains when and how to use FBMaintenanceManager?
Thanks,
Alec
The last line in the following code throws "GDS Exception. 335544792. Cannot
attach to services manager".
// start embedded Firebird server
FBManager manager = new FBManager("EMBEDDED");
manager.start();
MaintenanceManager maintenanceManager = new
FBMaintenanceManager("EMBEDDED");
maintenanceManager.setDatabase(getDatabaseFile().getAbsolutePath());
Is there a document which explains when and how to use FBMaintenanceManager?
Thanks,
Alec
On Mon, Oct 12, 2009 at 12:23 PM, Roman Rokytskyy <roman@...>wrote:
>
>
>
> > What command or JDBC url switch should I use to turn ForcedWrites off via
> > JayBird?
>
> The correct way is to use FBMaintenanceManager class, there are an
> appropriate methods for changing the DB configuration.
>
> > What other optimizations would you recommend to speed up our tests?
>
> "Doctor, I'm feeling not very well, what medicine should I take?" :)
>
> There might be a plenty of issues, not necessarily related to the disk.
> Without profiling the test suite it is hard to say anything. You might
> play with buffers, but also a simple caching of prepared statements
> improves the performance significantly. You might have issues with the
> queries (bad indexes), or implicit datatype/charset conversions.
>
> Roman
>
>
[Non-text portions of this message have been removed]