Re: [firebird-support] Re: Why it's soo slow ? it's just a very simple select ...

2012-03-08 Thread Doug Chamberlin
Top posting is when your reply is above the quoted message you are replying to. This message from me uses top posting. In your message in response to Thomas, which is quoted below, you used bottom posting. Bottom posting is strongly preferred by many people because it is more organized to add your

Re: [firebird-support] Re: Why it's soo slow ? it's just a very simple select ...

2012-03-08 Thread Lester Caine
nathanelrick wrote: >> Can you please stop top-posting, because this removes the context of >> > your reply. Or do you read a book from the end to the beginning?;-) > sorry i not understand ? i simply in yahoo.com go to the message and click > "reply" to the message that all ? what i do wrong ? w

[firebird-support] Re: Why it's soo slow ? it's just a very simple select ...

2012-03-08 Thread nathanelrick
> Can you please stop top-posting, because this removes the context of > your reply. Or do you read a book from the end to the beginning? ;-) sorry i not understand ? i simply in yahoo.com go to the message and click "reply" to the message that all ? what i do wrong ? what is "top-posting" ?

Re: [firebird-support] Backup and restore of users

2012-03-08 Thread Aldo Caruso
Thanks all of you for your help. Aldo Caruso El 08/03/12 07:04, Tomasz Tyrakowski escribió: > > I had run it just before posting, on one of our servers. Debian 6, FB > 2.5.0 CS. Worked all right. > You're right about Windows. Just checked it and got "no permission for > direct access to security d

Re: [firebird-support] Re: Why it's soo slow ? it's just a very simple select ...

2012-03-08 Thread Thomas Steinmaurer
> yes, i know how to do a pool of statement, i thing i will do it easily ... > but now the question is it normal that a "PREPARE" use so much of time ? is > it not look like a conception error in the engine ? Can you please stop top-posting, because this removes the context of your reply. Or do

[firebird-support] Re: Why it's soo slow ? it's just a very simple select ...

2012-03-08 Thread nathanelrick
yes, i know how to do a pool of statement, i thing i will do it easily ... but now the question is it normal that a "PREPARE" use so much of time ? is it not look like a conception error in the engine ? --- In firebird-support@yahoogroups.com, "Benno" wrote: > > Hi, > > > >EX: user 1 come and

[firebird-support] Re: Why it's soo slow ? it's just a very simple select ...

2012-03-08 Thread nathanelrick
> C'mon. This ain't bad. *g* Ever tried to do the same with the big guns > Oracle, MSSQL etc.? big gum? but Firebird is not a nuclear weapon compare to them ? :) > I'm afraid, this is only possible (if at all), if your middle-tier is > somehow caching prepared statements/objects available for

Re: [firebird-support] Re: Why it's soo slow ? it's just a very simple select ...

2012-03-08 Thread Benno
Hi, >EX: user 1 come and say i want info of obj 1 >few time after user 2 come and say i want the info of obj 98 >i still don't know how to keep the statement prepared between these 2 query >done by 2 different users... but i will investigate I would have a look at placing a middle tier in your

Re: [firebird-support] Re: Why it's soo slow ? it's just a very simple select ...

2012-03-08 Thread Thomas Steinmaurer
>> In the prepare step, roughly explained, the engine parses the SQL text, >> checks the syntax and compiles it into a Firebird native executable form >> (BLR). > > Yes this what i understand too, and this why 50 ms seem huge ... > > >> My guess is that you are assigning the SQL text over and over

Re: [firebird-support] Re: Firebird ODBC driver: connection to an embedded server by using security2.fdb

2012-03-08 Thread Thomas Steinmaurer
Patrick, > Thomas? Anyone else? :) > > I would like to get those 3 parts sorted and need some help here... Things are getting hard to follow, if top-posting is used in replies. See my comments inline ... > --- In firebird-support@yahoogroups.com, "patrick_marten" > wrote: >> >> Hello Thomas,

Re: [firebird-support] Importing from spreadsheet

2012-03-08 Thread Mags Phangisa
Thanx to everyone for your assistance. Much appreciated. On Wed, Feb 29, 2012 at 2:33 PM, Milan Babuskov wrote: > ** > > > Mags Phangisa wrote: > > Is there a way I can import data from a spreadsheet into a table? Any > help > > will be greatly appreciated. > > Save to CSV format and use XMLWiza

[firebird-support] Re: Why it's soo slow ? it's just a very simple select ...

2012-03-08 Thread nathanelrick
> In the prepare step, roughly explained, the engine parses the SQL text, > checks the syntax and compiles it into a Firebird native executable form > (BLR). Yes this what i understand too, and this why 50 ms seem huge ... > My guess is that you are assigning the SQL text over and over again,

[firebird-support] Re: Firebird ODBC driver: connection to an embedded server by using security2.fdb

2012-03-08 Thread patrick_marten
Thomas? Anyone else? :) I would like to get those 3 parts sorted and need some help here... --- In firebird-support@yahoogroups.com, "patrick_marten" wrote: > > Hello Thomas, > > sorry for the late reply. I got distracted by other things :( > > Now that some time has passed, I'm having troub

Re: [firebird-support] Backup and restore of users

2012-03-08 Thread Tomasz Tyrakowski
I had run it just before posting, on one of our servers. Debian 6, FB 2.5.0 CS. Worked all right. You're right about Windows. Just checked it and got "no permission for direct access to security database". I haven't thought about testing it on Windows - sorry Aldo, my solution only half-works.

Re: [firebird-support] Backup and restore of users

2012-03-08 Thread Thomas Steinmaurer
Hello Tomasz, > gbak -B /opt/firebird/security2.fdb ./security2.fbk > > works as well. Restoring requires two steps: restore to an alternate > location (gbak -C security2.fbk somefolder/security2.fdb), then stop the > server (SS) or close connections (CS) and copy the restored > security2.fdb to t

Re: [firebird-support] Backup and restore of users

2012-03-08 Thread Tomasz Tyrakowski
gbak -B /opt/firebird/security2.fdb ./security2.fbk works as well. Restoring requires two steps: restore to an alternate location (gbak -C security2.fbk somefolder/security2.fdb), then stop the server (SS) or close connections (CS) and copy the restored security2.fdb to the proper location in F

[firebird-support] Re: Why it's soo slow ? it's just a very simple select ...

2012-03-08 Thread philippe makowski
nathanelrick [2012-03-08 08:59] : > I agree, what will be good is to have something like a "hotline" support > service ... if someone have some offer i will be happy to receive it IBPhoenix provide this http://www.ibphoenix.com/services

Re: [firebird-support] Precision in stored procedures

2012-03-08 Thread Tomasz Tyrakowski
Just one remark in addition to what Thomas Steinmaurer has already shown you. Do not believe blindly in what stored procedure debuggers show you. What you see in the debugger window, as being the value of a SP variable, is not neccesarily the same as the actual value in the server process. Try

Re: [firebird-support] Re: Why it's soo slow ? it's just a very simple select ...

2012-03-08 Thread Thomas Steinmaurer
>> In all three cases you are< 50ms, so what's the problem? Your niggles >> are in the millisecond area right now. ;-) > > oupps, but 50 ms it's ok when you do time to time, but when you have 50 > client (and that not too much for a web service) doing this at the same time > then the 50 ms becom

[firebird-support] Re: Why it's soo slow ? it's just a very simple select ...

2012-03-08 Thread nathanelrick
> In all three cases you are < 50ms, so what's the problem? Your niggles > are in the millisecond area right now. ;-) oupps, but 50 ms it's ok when you do time to time, but when you have 50 client (and that not too much for a web service) doing this at the same time then the 50 ms become 0.5 se