I tried to migrate MySQL DB to Firebird 2.5 IB DataPump, but migration fails.
It successfully gets connected to MySQL (Source DB), but it is unable to set
relationship to the Firebird (Target DB).
Sometimes it even doesn't displays MySQL Provider in the ADO Source of the
Source DB. Is there an
I am working in an older version of IB that does not have the GEN_UUID()
function, so I am working on implementing the function as a UDF, but it is
giving me an "arithmetic exception, numeric overflow, or string truncation". I
looking at the FB source to see how it is implemented there, but int
Hi,
I want to use firebird single file database for my ASP.NET web application. I
want to know how to host a firebird DB?
Regards,
Rohit.
[Non-text portions of this message have been removed]
On Wed, Sep 28, 2011 at 12:59 PM, Mark Rotteveel wrote:
> On Wed, 28 Sep 2011 11:52:01 -0400, Ann Harrison
> wrote:
> >> 2. What is the table and data file max-size for version 2.5?
> >>
> >
> > I think it's 32K * the page size. Huge.
>
> Hi Ann, I assume you mean something like 2^32 * pagesize
I recently upgraded to FB2.5 from FB1.5, very impressed am I. Doing a
backup using flamerobin took approximately 7 seconds, my current stats
are:
Database info
ODS Version 11.2
Page Size 8192
Pages 15382
Size on Disk 120.17MB
SQL Dialect 3
Default Character Set ISO8859_1
Settings
Page Buffers 20
On Wed, Sep 28, 2011 at 18:48, Alexey Kovyazin wrote:
>> 1) Full hard disk: IIRC in this case Firebird will overwrite the file
>> from the beginning. Not good, but checking for free space on every
>> write would slow down writes too much. Just make sure you have enough
>> space.
>>
>
> This is far
On Wed, 28 Sep 2011 11:52:01 -0400, Ann Harrison
wrote:
>> 2. What is the table and data file max-size for version 2.5?
>>
>
> I think it's 32K * the page size. Huge.
Hi Ann, I assume you mean something like 2^32 * pagesize, because 32K * a
pagesize of 16K isn't that much (roughly 512MB) :P
M
Hello,
>
> > 3. What are the common scenarios of a Firebird data file getting
> corrupt? In case of a single-file structure, I guess no other files
> need to be backed up?
>
There are some articles on our site
Firebird and InterBase corruptions reasons
http://www.ib-aid.com/articles/item70
On Wed, Sep 28, 2011 at 15:58, Rohit Coder
wrote:
> 2. What is the table and data file max-size for version 2.5?
http://www.firebirdfaq.org/faq61/
> 3. What are the common scenarios of a Firebird data file getting corrupt? In
> case of a single-file structure, I guess no other files need to be
Hi Rohit,
> I am a SQL Server and MySQL developer. ]
'welcome!
>
> 1. Which is the recommended data file structure: `Single file` or
> `Multiple files`?
>
Single file. The multiple file structure was invented when databases were
bigger than disks. Even the multiple-file configuration mix
Hi Rohit Coder,
welcome to Firebird!
> 1. Which is the recommended data file structure: `Single file` or `Multiple
> files`?
I'll pass on this one. I may give wrong information.
> 2. What is the table and data file max-size for version 2.5?
Ditto.
> 3. What are the common scenarios of a
Hi,
I am a SQL Server and MySQL developer. I am aware of Firebird but never got
opportunity to work with it. I want to use Firebird in one of my upcoming
project replacing MySQL. While reading the documentation of Firebird, I learned
that it supports single as well as multiple database files o
Hello all,
I'm new to this group, but already have a bit of experience with IB/FB
(been playing with them since IB4). I've already benefited from the
experience of the members of this group by searching through the list
archives (btw, I'll do my best to stay a member and contribute as much
as
> CREATE TABLE posts
> (
> board_id,
> username,
> PRIMARY KEY (board_id, username)
>)
>
> SELECT COUNT(*) FROM posts WHERE board_id = 1;
>
> There are 123k rows in the posts table (just a sample) and all of them
> are of board_id = 1. This query takes about 0.5-1 sec to run (slow).
>
> I'm
14 matches
Mail list logo
