Re: [firebird-support] Basic Start

2017-03-14 Thread Slavomir Skopalik skopa...@elektlabs.cz [firebird-support]
Yes, look here: public static void CreateDatabase(string connectionString, int pageSize = 4096, bool forcedWrites = true, bool overwrite = false) { CreateDatabaseImpl(connectionString, pageSize, forcedWrites, overwrite); } As connection string you can use file name. Look for example here:

Re: [firebird-support] Basic Start

2017-03-14 Thread Clyde Eisenbeis cte...@gmail.com [firebird-support]
Thanks for the prompt response! I've read through portions of the Quick Start Guide ... information overload. It's difficult to read all of the options, many of which are not applicable. 1) I decided to try using NuGet ... which provided me with a Firebird installation ... which I think is

RE: [firebird-support] Re: High "Mutex wait" value, after increase in "Hash Slots" to 90001

2017-03-14 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
> > OWNER BLOCK 732776 > > Owner id: 114332029419524, type: 1, pending: 0 > > Process id: 26620 (Alive), thread id: 2348 > > Flags: 0x08 wake > > Requests (431): forward: 732888, backward: 10111616 > > Blocks: *empty* > > 732776 waits on nothing. > > > >

Re: [firebird-support] Basic Start

2017-03-14 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.03.2017 18:32, Clyde Eisenbeis cte...@gmail.com [firebird-support] wrote: > 2) Can I create a Firebird database file? ... as I did with SQLite ... No. Firebird is a client-server DBMS, closer to Oracle than file-server like SQLite. Read Firebird Quick Start Guide. -- WBR, SD.

[firebird-support] Basic Start

2017-03-14 Thread Clyde Eisenbeis cte...@gmail.com [firebird-support]
I've recently written code using SQLite (C# .NET, using System.Data.SQLite) ... decided to try Firebird. To install Firebird: Visual Studio 2013 -> File -> New -> Project, etc. -- then Tools -> Library Package Manager -> Manage NuGet Packages -> search "firebird" -> Firebird ADO.NET Data

[firebird-support] Re: High "Mutex wait" value, after increase in "Hash Slots" to 90001

2017-03-14 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
14.03.2017 20:54, 'Leyne, Sean' wrote: > > The -o -w switches generated details such as: > > OWNER BLOCK 732776 > Owner id: 114332029419524, type: 1, pending: 0 > Process id: 26620 (Alive), thread id: 2348 > Flags: 0x08 wake > Requests (431): forward: 732888,

RE: [firebird-support] Re: High "Mutex wait" value, after increase in "Hash Slots" to 90001

2017-03-14 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
Dmitry, > > Am I right to think that I need to create a process to run the command on a > regular basis (every 5 secs?) to find what objects locks are waiting for? > > Yes. But we're still guessing in the dark, the reason of the slowdown could be > completely unrelated to the lock manager (e.g.

Re: [firebird-support] Read only transaccions and generators

2017-03-14 Thread 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support]
Hello Aldo, Generators are NOT influenced by transactions, so yes, that is correct. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL, SQL Anywhere, MySQL, InterBase, NexusDB and Firebird.

Re: [firebird-support] Read only transaccions and generators

2017-03-14 Thread Hannes Streicher hstreic...@gmx.de [firebird-support]
Guten Tag Aldo Caruso aldo.car...@argencasas.com [firebird-support], Generators/Sequences operate outside of transactions , so: yes. > Hello, > I discovered that a read only transaction can increment a generator. > Is that right ? > Thanks > Aldo >

[firebird-support] Shutdown database issue

2017-03-14 Thread hugo.lar...@yahoo.com [firebird-support]
Hello, I'm running firebird 2.5-super on Ubuntu 16.04. I want to restore a database with nbackup and before I do that I shut down the particular database file and delete the file and after that restore. Sometimes during shutdown I get the one of these exceptions: GDS Exception. 335544835.