Thread: [Firebird-devel] (no subject) (Page 2)

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Hi,

Is there any plans to integrate Yaffil optimizations in a short =
timeframe?
I=B4m asking because some benchmarks I=B4ve made using some big tables =
(300K
recs) shows that Yaffil always outperforms FB 1.5:

create table mov_pe(client int,shipper int,salesperson int, =
delivery_date
date, product int, color int, pattern int, size varchar(5), qty
numeric(15,7), price numeric(15,2),mov_type int);

Create index idx_1 on mov_pe(mov_type);
Create index idx_2 on mov_pe(product);

Create table mov_types(mov_type int, mov_code varchar(1));
Create unique index idx_3 on mov_types(mov_type);

Create table products(product int,brand int);
Create unique index idx_4 on products(product);
Create index idx_5 on products(brand);

Create table brands(brand int,brand_name varchar(50));
Create unique index idx_6 on brands(brand);

Avg table sizes:
mov_pe: 300.000 recs
mov_types: 30 recs
products: 6.000 recs
brands: 15 recs

The query is:

Select brand_name,sum(qty),sum(qty*price) from
Brands b
Inner join products p on b.brand=3Dp.brand
Inner join mov_pe mp on mp.product=3Dp.product
Inner join mov_types mtp on mtp.mov_type=3Dmov_pe.mov_type
Where mtp.mov_code=3D'V';

Execution time for this query:

FB 1.3:  9   secs
FB 1.5:  7.5 secs
Yaffill 872b 4 secs

As you see its a huge difference. FB 1.5 is a lot faster than FB 1.3, =
but
merging Yaffil optimizations can make FB 1.? Faster even faster than =
Yaffil.

Thanks for your attention and for your great contribution,

Gustavo Hispagnol
Millennium Network

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.688 / Virus Database: 449 - Release Date: 18/05/2004
=20

> Execution time for this query:
>
> FB 1.3:  9   secs
> FB 1.5:  7.5 secs
> Yaffill 872b 4 secs
>
> As you see its a huge difference. FB 1.5 is a lot faster than FB 1.3, but
> merging Yaffil optimizations can make FB 1.? Faster even faster than
Yaffil.

Is the plan generated by yaffil different from plans created by FB?
Could you send generated plans for this query?

Regards
Daniel Urban

Hello
I would like to know how can I INSERT values to table where one of
columns is an Array, and is there a possiblity using data net
provider (1.7) work with it.
to sure  I would put my tables as example.
-------------------first table-----------------------
CREATE TABLE SETTINGS(
SET_ID SMALLINT NOT NULL PRIMARY KEY,
SPEEDS DECIMAL (7,2)[1:20],
TIMERS DECIMAL (7,2)[1:20],
M_DATA DECIMAL (7,2)[1:20]
------------------second table---------------------
CREATE TABLE MAIN(
SET_ID SMALLINT,
LENGHT DECIMAL(5,2),
WIDTH DECIMAL(5,2)
.
.
.
PROGS SMALLINT,
QUEUE BIGINT NOT NULL PRIMARY KEY
FOREIGN KEY (SET_ID) REFERENCES SETTINGS (SET_ID)
ON UPDATE CASCADE ON DELETE CASCADE
);
and I would like to do such thing:
INSERT INT SETTINGS () ?? but I do not know HOW ??
SELECT * FROM MAIN JOIN SETTINGS ON (MAIN.SET_ID =3D SETTINGS.SET_ID)

Hello.
I've downloaded a sourcode of Firebird under Linux OS. But it can be
compiled under i686 architecture only. I compile under Mandrake Linux
OS. I need to compile it under PowerPC architecture. The compiler
under this architecture exists, but sourcecode is not compiled. Where
is the problem? The sourcecodes of other programs are compiles and run
normally. Maybe i have to download another sourcecode? If yes, tell me
where can I find it please.
Best regards,
Tenyakova Rosa  mailto:ro...@ne...

0uXt/+ru4uAg0O7n4CDC4PHo6/zl4u3gIHdyb3RlOg0KPiBIZWxsby4NCg0KSSd2ZSByZXBs
aWVkIGhlciBwcml2YXRlbHkuDQo=

=D2=E5=ED=FF=EA=EE=E2=E0 =D0=EE=E7=E0 =C2=E0=F1=E8=EB=FC=E5=E2=ED=E0 wrot=
e:
> Hello.
> I've downloaded a sourcode of Firebird under Linux OS. But it can be
> compiled under i686 architecture only. I compile under Mandrake Linux
> OS. I need to compile it under PowerPC architecture. The compiler
> under this architecture exists, but sourcecode is not compiled. Where
> is the problem? The sourcecodes of other programs are compiles and run
> normally. Maybe i have to download another sourcecode? If yes, tell me
> where can I find it please.
> Best regards,
> Tenyakova Rosa  mailto:ro...@ne...

You have not mentioned that you need to cross-compile firebird for=20
PowerPC on computer with another architecture. This is not trivial task.

Where can I download the FB2 RC4 Windows superserver binary? I cannot 
find it on SourceForge.

At 02:29 AM 2/10/2006, you wrote:
>Where can I download the FB2 RC4 Windows superserver binary? I cannot
>find it on SourceForge.

It's 
http://prdownloads.sourceforge.net/firebird/Firebird-2.0.0.12724-0-Win32.exe
but the easiest way to get the kits for the latest beta is to click 
through to its index page from the "CURRENTLY TESTING" link at 
http://www.firebirdsql.org

Helen

-- 

The information contained in this e-mail message and any attached files 
are confidential information. If you are not the intended recipient, 
please notify us immediately by reply e-mail to sender. It is your 
responsibility to scan this communication and any files attached for 
computer viruses. AWS Pty Ltd maintains up to date virus software on our 
network and do not warrant, represent, or guarantee the accuracy or 
completeness of any information contained in this e-mail attached files. 
AWS Pty Ltd does not accept liability for loss or damage (whether 
direct, indirect, consequential or economic) however caused, and whether 
directly or indirectly from this e-mail or any attached files.

Hi,

 Opps ! Sorry I used the 1.5.4.4910 build. I downloaded it from
http://www.firebirdsql.org/index.php?op=files&id=engine_154

 Also I need to use 1.5.x as we also deploy to interbase clients which
still use the old security database. It would take a while to write the
code to figure out which version they are using when creating users for
my app, I have not got time right now to do this.

From,

Phillip

> Philip,
>
> Thats all very good :-)
> But could you tell me which source tar ball you are using, or
> what tag you checked out of CVS?
>
> Regards
> Paul
>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
> your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>

On Tuesday 27 March 2007 12:15, ph...@ar... wrote:
> Hi,
>
>  Opps ! Sorry I used the 1.5.4.4910 build. I downloaded it from
> http://www.firebirdsql.org/index.php?op=files&id=engine_154
>
>  Also I need to use 1.5.x as we also deploy to interbase clients which
> still use the old security database. It would take a while to write the
> code to figure out which version they are using when creating users for
> my app, I have not got time right now to do this.

BTW, the only security-database related problem you will get with old 
interbase client (reasonably old), is isc_(add/modify/delete)_user calls not 
working. Login/password validation and even management using services API 
should work.

As Dimitry says XCode 2.4.1 is the latest and uses gcc 4.01
You need a version of Xcode that uses gcc 3.x

Paul

Dear Paul,

 Thanks. I will try to get a version of Xcode which is supported on Intel
Mac which has gcc 3.x.

From,

Phillip

>
> As Dimitry says XCode 2.4.1 is the latest and uses gcc 4.01
> You need a version of Xcode that uses gcc 3.x
>
> Paul
>
>
>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
> your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>

>  Thanks. I will try to get a version of Xcode which is supported on Intel
> Mac which has gcc 3.x.

Problem is - I don't think you will have much luck, I seem to remember that
there isn't such a beast...

Paul

Hi Paul,

 I have found this link

http://developer.apple.com/releasenotes/DeveloperTools/RN-GCC3/

Which talks about gcc 3 in Xcode, you can also set the version of gcc to
use with something like

sudo /usr/sbin/gcc_select 3

 However it also says "In Xcode 2.1 and higher, the gcc 3.3 compiler does
not support generating code for x86"

I will keep looking for the highest Version 3 they released, which may
support x86.

Someone has compiled it before on x86 as I have got the binaries to work :)
Unless the are universal binaries....
http://developer.apple.com/documentation/MacOSX/Conceptual/universal_binary/index.html

 I can program in C and a bit in C++, can someone explain the reason it
will not work with gcc 4.x. Maybe I could change the makefile / code ?

From,

Phillip

>
>>  Thanks. I will try to get a version of Xcode which is supported on
>> Intel
>> Mac which has gcc 3.x.
>
> Problem is - I don't think you will have much luck, I seem to remember
> that
> there isn't such a beast...
>
> Paul
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
> your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>

I am using Firebird 1.5=20
I want to save my atabase on the ASUS WL-700gE router ( it is wierless rout=
er with HDD)   but the HDD see it in my pc as netword drive , and in realy =
I can't setup service ther it is not pc=20
 what can I do to make database on ASUS WL-700gE HDD  ?
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/=

On Wednesday 12 December 2007 18:58, samer kanji wrote:
> I am using Firebird 1.5
> I want to save my atabase on the ASUS WL-700gE router ( it is wierless
> router with HDD)   but the HDD see it in my pc as netword drive , and in
> realy I can't setup service ther it is not pc what can I do to make
> database on ASUS WL-700gE HDD  ?

There is configuration parameter making it possible to have database on NFS 
share. But I do not remember exactly, is it present in 1.5 or only in 2.0.

Hello,
We are trying to compile Firebird 2.1
for Android in order to use the embedded version in our mobile device
of our software.
But
for the moment it seems impossible for some reasons : Android
uses his own Libc called Bionic. And the problem is that there is a
lot of missing features in. There is no implementation of the POSIX
IPC or System V IPC inside, Android drop this to avoid
denial-of-service. So, use of
semaphore, shared memory, etc,  is not possible. 

We
have written a more complet document of this porterage which
describes the problems in detail.

Somebody
have already attempt to compile or to make an Android version of
Firebird ?
What
would be the good way to do that ?
Otherwise,
how to interest Firebird developpers to make this Android version ?
(Maybe I can create a topic in the tracker )
Thanks
in advance.

Jean-Louis Meuriot

19.07.2012 10:57, J-L M wrote:
> What would be the good way to do that ?

   Complain to Google and force them to expand their "Bionic".

-- 
   WBR, SD.

-=| J-L M, 19.07.2012 10:57:53 +0200 |=-
> We are trying to compile Firebird 2.1
> for Android in order to use the embedded version in our mobile device
> of our software.
> But
> for the moment it seems impossible for some reasons : Android
> uses his own Libc called Bionic. And the problem is that there is a
> lot of missing features in. There is no implementation of the POSIX
> IPC or System V IPC inside, Android drop this to avoid
> denial-of-service. So, use of
> semaphore, shared memory, etc,  is not possible.

Perhaps you can try 2.5? It no longer uses semaphores.

Not sure about the availability of pthread mutexes in bionic, though.

Thread: [Firebird-devel] (no subject) (Page 2)

A powerful, cross platform, SQL database system

firebird-devel