Re: [Firebird-devel] Restore improvements?

2012-09-12 Thread Kjell Rilbe
Den 2012-09-12 00:20 skrev Dmitry Kuzmenko såhär:
> I think here OS cache is more sufficient, especially for databases 
> that bigger than RAM. Here one thought came to me, that was inspired 
> by Vlad Horsun - to restore all indices per table, table by table, not 
> that way like gbak restores indices in current versions (all foreign 
> keys goes at the end). 

In regular DB use (not restore), when multiple indices are created in a 
single transaction, will FB read through the data pages once for each 
index creating them serially, or will it read the data pages once for 
all indices, creating them, so to say, in parallel (not meaning multiple 
threads or anything)?

I'm thinking that reading the data pages once for multiple indices would 
be beneficial not only for DB restore, but the same mechanism should be 
possible to use whenever multiple indices are created in a single 
transaction.

Kjell

-- 
--
Kjell Rilbe
DataDIA AB
E-post: kj...@datadia.se
Telefon: 08-761 06 55
Mobil: 0733-44 24 64



--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


Re: [Firebird-devel] Restore improvements?

2012-09-12 Thread Adriano dos Santos Fernandes
On 12/09/2012 02:54, Thomas Steinmaurer wrote:
> gbak restore performance is bound to the performance of a single 
> core/CPU, thus running the index creation process in parallel, sounds 
> encouraging. This is even getting more important (worse) with a faster 
> I/O system (SSD ...). I'm not talking about utilizing several cores for 
> a single index creation statement though (which would be cool, but is an 
> area for Oracle and the PARALLEL clause).
>
>
I once tried to create multiple indexes simultaneously on different
attachments and saw no improvements. That's with standard HDD...

You may try that with SSD and check the results to see if gbak and/or
engine changes worth it.


Adriano


--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


Re: [Firebird-devel] RFC - FB 3.0 IPv6 support

2012-09-12 Thread Ben Green
Hello Everyone,

Further to my previous email, I have looked again at my patch and adapted it to 
work with the new versions of Firebird. I am having some difficulty getting the 
current HEAD Firebird 3.0 running on Linux, although it is working fine in 
Windows.

Anyway, the updated patch, tested on Windows 7 and Windows XP compiled with 
Visual Studio 2008 and on Linux (Gentoo) and GCC 4.5.3 for Firebird 2.5.2 
(revision 57120):

http://www.bengreen.eu/fancyhtml/techiestuff/files/firebird252-ipv6.diff

You can see the discussions I had with Alex in November of 2010 when I wrote 
the first patch, if you are interested:

http://sourceforge.net/mailarchive/forum.php?forum_name=firebird-devel&max_rows=25&style=ultimate&viewmonth=201011


Let me know what you think.

Kind regards,

Benjamin.



 From: Ben Green 
To: For discussion among Firebird Developers 
 
Sent: Tuesday, 4 September 2012, 16:18
Subject: Re: [Firebird-devel] RFC - FB 3.0 IPv6 support
 

Hi Michal,

I implemented IPv6 support some time ago for both Windows and Linux, tested 
with Visual Studio 2010 and Gentoo Linux... my patch is old now and so does not 
apply properly to the current tree. I would like to have IPv6 support in 
Firebird so would be happy to work with you on this, firstly to update my patch 
;-).

I will get my development environment set up again for the Windows port and get 
back to you.

Patch available here http://www.bengreen.eu/clients/firebird/firebird-ipv6.diff

Benjamin



 From: Michal Kubecek 
To: firebird-devel@lists.sourceforge.net 
Sent: Tuesday, 4 September 2012, 15:32
Subject: [Firebird-devel] RFC - FB 3.0 IPv6 support
 
Hello,

Attached is a patch series implementing IPv6 support for current HEAD.

I did some testing including events handling (aux connections) and
interoperability with 2.5 and everything seemed to work correctly. But
as I could test only on Linux, I'm not sure it will work correctly on
other platforms, especially on Windows so that I'll welcome anyone
willing to test or review the code.

There is one issue I know about: on some systems, IPv6 socket bound to
:: address doesn't accept IPv4 connections and two listening sockets
need to be created. I'm not sure whether to use a separate thread(s) or
let select()/poll() handle both sockets. Any suggestions?

Note: for OpenSuSE and SLE, ready-to-use packages are
 built in
home:mkubecek:firebird30:ipv6 OBS project and can be downloaded from

http://download.opensuse.org/repositories/home:/mkubecek:/firebird30:/ipv6/

                                                         Michal Kubeček


--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel



--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel