[firebird-support] Data Type for Primary Key

[Kevin Meyers kevinjmey...@gmail.com [firebird-support]]

I am wondering if any of you have every noticed any significant performance
difference between using BIGINT versus INTEGER as an autoincremented
primary key in Firebird. My idea is to use BIGINT and have virtually
unlimited records ("set it and forget it" approach), but if I am going to
incur a real performance hit, I would probably use INTEGER instead. I've
done some modest testing and haven't noticed much difference, but I am
wondering what you all have experienced in real world situations.

Thanks in advance,

Kevin

[firebird-support] Data Type for Primary Key

[Kevin Meyers kevinjmey...@gmail.com [firebird-support]]

I am wondering if any of you have every noticed any significant performance
difference between using BIGINT versus INTEGER as an autoincremented
primary key in Firebird. My idea is to use BIGINT and have virtually
unlimited records ("set it and forget it" approach), but if I am going to
incur a real performance hit, I would probably use INTEGER instead. I've
done some modest testing and haven't noticed much difference, but I am
wondering what you all have experienced in real world situations.

Thanks in advance,

Kevin

[firebird-support] Reporting for Firebird in Visual Studio 2013 (C#)

[Kevin Meyers kevinjmey...@gmail.com [firebird-support]]

Hello -- I'm looking for some suggestions on a reporting tool that works
well within the Visual Studio 2013 IDE using Firebird 2.5.4.


I've tried using the Crystal Reports add-in. While it works fine within the
IDE, when I build and run the app, it keeps asking for my login
credentials. Have not found a way around this. If you know of one, please
let me know and I will continue to explore using Crystal Reports.


Thanks!


Kevin

Re: [firebird-support] Reporting for Firebird in Visual Studio 2013 (C#)

[Kevin Meyers kevinjmey...@gmail.com [firebird-support]]

Thanks, Louis. I appreciate the suggestions and I will definitely check out
DevExpress.

On Wed, Sep 2, 2015 at 4:18 PM, 'Louis van Alphen' lo...@nucleo.co.za
[firebird-support]  wrote:

>
>
> Not sure if this is what you are looking for, but I use DevExpress for all
> my data analytical/visualisation tools. DevExpress have the best reporting
> & data visualisation components by far. Very easy to integrate into C# apps
> and great support.
>
> All my apps have an analytics module that allows me and end users to
> design and run pivots, reports and dashboards at runtime. I built a lot of
> stuff around DevExpress to achieve that and make it reusable in all my
> apps. The metadata definitions for reports/pivots/dashboards are stored in
> FB tables. This means that users can create a report, plug in the SQL,
> including parameters and then design the report.
>
> From: firebird-support@yahoogroups.com [mailto:
> firebird-support@yahoogroups.com]
> Sent: 02 September 2015 09:44 PM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Reporting for Firebird in Visual Studio 2013
> (C#)
>
>
> Hello -- I'm looking for some suggestions on a reporting tool that works
> well within the Visual Studio 2013 IDE using Firebird 2.5.4.
>
> I've tried using the Crystal Reports add-in. While it works fine within
> the IDE, when I build and run the app, it keeps asking for my login
> credentials. Have not found a way around this. If you know of one, please
> let me know and I will continue to explore using Crystal Reports.
>
> Thanks!
>
> Kevin
>
> [Non-text portions of this message have been removed]
>
> 
>

Re: [firebird-support] Securing database against corruption on systems that suddenly get turned off

[Kevin Meyers kevinjmey...@gmail.com [firebird-support]]

Glenn,

My suggestion is to connect the computer in question to an Uninterruptable
Power Supply (UPS), which contains a battery as a power backup. When it
senses a complete power loss (blackout), an undervolt (brownout), or an
overvolt it immediately switches the source of power for your computer from
the wall outlet to the battery. One power is restored, the UPS switches
back to the wall outlet AC and recharges the battery.

Most units except for the smallest ones come with a USB cable and software
to connect to the computer so that if it using the battery and the battery
drains it instructs your computer to perform a Shutdown. This would give
you the "soft landing" to avoid the corruption you are encountering.

With mine I find that sometimes the momentary loss of power is so short
that I don't even notice it, but the UPS does as I hear it click on for few
seconds. I'm glad the UPS catches them, because I'm sure my PC notices them.

Hope this helps.

Regards,

Kevin Meyers

On Mon, Sep 21, 2015 at 4:53 AM, Glenn Thomas Hvidsten g...@vensafe.no
[firebird-support]  wrote:

>
>
> Hi,
>
>
>
> We have FirebirdSQL (2.1) running on a client computer (Windows). This
> client has some problems with his power grid which causes the PC to
> suddenly and unexpectedly shut down in infrequent intervals (usually once
> or twice per day). Most of the time this doesn’t cause any problems, but
> once in a while this causes the database to be corrupted.
>
> I’m not at all surprised that the database gets corrupted like this (as
> turning off a computer without shutting everything down gracefully can have
> that effect).
>
>
>
> Are there any options available that can make a database more sturdy
> against these kinds of corruptions?
>
>
>
>
>
> Cheers
>
>
>
> Glenn Thomas
> --
> Denne epost har blitt kontrollert for virus av Comendo Norge AS
> 
> This e-mail has been scanned for viruses by Comendo Norge AS
> 
> --
>
> 
>