Anyway, OLAP and OLTP are general database concepts, not only applied to
Firebird. Wikipedia and other Google sources will give you enough
informations to play with. If you want a more academic approach, you could
look to this awesome book:
http://www.amazon.com/Fundamentals-Database-Systems-Ramez-
I'm pretty sure that what the article means (although not clearly
especified), is that you should have two firebird instances with 2
separated databases.
These databases should be replicated from one (OLTP) to another (OLAP) in
any way you think is best for your case.
On Fri, Apr 26, 2013 at 10:
Or you could use SQLite.
On Fri, Apr 19, 2013 at 11:30 AM, mickael.trecant wrote:
> Hello ,
>
> For that case , I'd rather store data in something like XML file or text
> in the android device , then use a small application at the office to
> export to firebird Database or a function directly i
Do you need to calculate this on the database? Can you not populate a table
with the numbers found on the internet? =)
Best Regards
On Tue, Jan 15, 2013 at 4:16 PM, Roberto Carlos wrote:
> The example below is from PostgreSQL. Is there an easy way to do it in
> Firebird 2.5 or 3.0?
>
> I need
mittently a process will almost stop and
> will stay that way for several hours
>
> how did you prove that was the cause?
>
>
> On 15 January 2013 15:59, Leonardo Carneiro
> wrote:
>
> > **
> >
> >
> > Hi Nick. I've found that my applications ALM
Hi Nick. I've found that my applications ALMOST hang when sweep is running
in big databases (100GB+).
I say almost because once in a while the application give a sign of life.
To "solve" the problem, i disabled the autosweep and run in a scheduled
task every dawn.
Best regards.
On Tue, Jan 15,
Gabe, i don't want to troll your thread or anything, but seriously, you're
my hero! Where are in 2013 and you're trying to make a program run in
windows 3.11. Your client should definitely give you a million dollar
payment!
On Fri, Jan 11, 2013 at 6:55 AM, Andy Gable wrote:
> Yea the PoS appli
Hi Andrew, search the internet for "transaction isolation levels". It will
give you a broader sight of how database systems in general handle this
kind of thing you're speaking of.
On Thu, Dec 27, 2012 at 12:15 AM, W O wrote:
> Well, surely there are several opinions but having a column for keep
Hi Svein,
Tks very much for your quick answer. Indeed, the statement did return one
row. Instead of adding it to POSICOES, i removed it from
EXCESSOS_VELOCIDADE. After this i was able to create the FK.
Again, thank you very much for your help.
2012/1/26 Svein Erling Tysvær
> Does this statemen
Hi everyone,
My software ran some DDL statements during a upgrade, and the creation of
one FK failed:
26.01.2012 10:18:53.703 | 3360 | INFO | TDBConnectionFirebird[0].ExecSQL:
ALTER TABLE EXCESSOS_VELOCIDADE ADD CONSTRAINT
FK_EXCESSOS_VEL_POSICAO_FINAL FOREIGN KEY (POSICAO_ID_FINAL) REFERENCES
PO
Hi everyone!
Generally speaking, is there any good pratices that i can try in order to
improve insert performances on a big table? I can't just throw the indices
away, since the table is very big and select performance would be
drastically reduced.
Some detais:
- Big table ( > 30 million rows
Tried IB-FirstAid+ trial, but gives me this messagem:
18:08:33 INFO: Open database files: C:\Arquivos de
programas\DDD_SYSTEM\Servidor\BD_COPY.FDB
18:08:33 Unrecognized database found.
On Thu, Nov 24, 2011 at 4:44 PM, Leonardo Carneiro
wrote:
> Wow, last error crashed the firebird process
Wow, last error crashed the firebird process =P. Could not connect to
others database in the same server. Had to kill the process =(
On Thu, Nov 24, 2011 at 4:19 PM, Leonardo Carneiro
wrote:
> Yep. When i first saw the mess, i deeply regreted the use of the -r switch
> =(
>
> Tried a
> loose some money from such unlucky guys :)
>
> Regards,
> Alexey Kovyazin
> IBSurgeon Ltd (www.ib-aid.com)
>
> ----- Reply message -
> From: "Leonardo Carneiro"
> To:
> Subject: [firebird-support] gfix mend full deadlock
> Date: Thu, Nov 24, 2011 20
Hi everyone,
I'm having a quite bad time with one database. The firebird version is
2.1.4, running on a windows server 2003 r2 enterprise. For some weird
reason, the previous administrator thought that would be fun to disable
forced writes while in production, so the database was running this way
On Thu, Nov 24, 2011 at 11:26 AM, Leonardo Carneiro
wrote:
> Hi everyone,
>
> Is there a way to check forced writes state (active or inactive) and alter
> this via a SQL command?
>
> Tks in advance.
>
Forgot to mention, i also want to check and alter the sweep interval, an
Hi everyone,
Is there a way to check forced writes state (active or inactive) and alter
this via a SQL command?
Tks in advance.
[Non-text portions of this message have been removed]
n Thu, Nov 17, 2011 at 9:57 AM, Leonardo Carneiro
wrote:
> Well, my brain become active again and i'm doing a copy of the database
> and will run the gfix against the copy. Stop firebird/copy database/start
> firebird.
>
>
> On Thu, Nov 17, 2011 at 9:34 AM, Leonardo Car
Well, my brain become active again and i'm doing a copy of the database and
will run the gfix against the copy. Stop firebird/copy database/start
firebird.
On Thu, Nov 17, 2011 at 9:34 AM, Leonardo Carneiro
wrote:
> Hi guys,
>
> Since the source database is still in production, i&#
e restored database i
have not one, but at least 10 dup keys in more than one table.
On Thu, Nov 17, 2011 at 7:44 AM, Leonardo Carneiro
wrote:
> Tks for the tips guys. I'll try both of then.
>
>
> On Thu, Nov 17, 2011 at 6:10 AM, Tomasz Tyrakowski <
> t.tyrakow...@sol-system.pl
Tks for the tips guys. I'll try both of then.
On Thu, Nov 17, 2011 at 6:10 AM, Tomasz Tyrakowski <
t.tyrakow...@sol-system.pl> wrote:
> My point exactly. That's why I adviced checking for duplicates _after_
> removing indices and primary keys on problematic tables. I've never
> tried the method p
s in the source database with all indices and primary
> keys on problematic tables removed. Also, verify the source database
> with gfix. If there are index page errors, you may get false results
> when you check for duplicate records.
>
> regards
> Tomasz
>
> On 2011-11-16
Hi everyone,
I have a database, running on Firebird 2.1.3 32bit on Windows XP. I did a
transportable backup and i'm trying to restore it in a Windows Server 2008
R2 with Firebird 2.1.4 64bit, using IBexpert.
The restore is OK, but some indexes are not being activated cause there
exist some duplic
On Fri, Sep 16, 2011 at 12:56 PM, Ann Harrison wrote:
> On Fri, Sep 16, 2011 at 4:07 AM, donovanbo...@ymail.com <
> donovanbo...@ymail.com> wrote:
>
> >
> > Eventually we turned to the log file generated by Firebird and found
> > numerous reports of this error INET/inet_error: read errno = 10054
>
On Tue, Sep 13, 2011 at 11:32 PM, Leonardo Carneiro
wrote:
> On Tue, Sep 13, 2011 at 5:53 PM, Ann Harrison wrote:
>
>> On Tue, Sep 13, 2011 at 3:45 PM, Leonardo Carneiro
>> wrote:
>>
>> >
>> > How do i get the id of the tuple of a table? I mean the ID of
On Tue, Sep 13, 2011 at 5:53 PM, Ann Harrison wrote:
> On Tue, Sep 13, 2011 at 3:45 PM, Leonardo Carneiro
> wrote:
>
> >
> > How do i get the id of the tuple of a table? I mean the ID of the tuple
> in
> > a
> > table, not the PK of the tuple. Have
Hello everyone,
How do i get the id of the tuple of a table? I mean the ID of the tuple in a
table, not the PK of the tuple. Have i jumped any doc that describe this?
tks in advance.
[Non-text portions of this message have been removed]
27 matches
Mail list logo
