Re: [Firebird-devel] Alpha 2 - Trace Output - Execution of package-based stored procedure
On 18/02/2014 19:26, Claudio Valderrama C. wrote: -Original Message- From: Thomas Steinmaurer [mailto:t...@iblogmanager.com] Sent: Martes, 18 de Febrero de 2014 17:02 Tried todays snapshot build (Win 32-bit). The output looks like a bit weird regarding package/procedure name: Procedure PKG_SCHE´õŸ: 0 ms Probable because the string created by QualifiedName.toString() goes out of scope before the contents can be copied. While it would be more tedious to use, I would prefer this function changed to string toString(string out) to ensure the result is written in out and not in a temporary object. Then you need to change every routine that returns a string. The problem is not with this function. The problem is where is passing a c_str() of a temporary object. Adriano -- Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121054471iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] ICU Data table customization
Hi! One thing of ICU we use and allows the user to use with CREATE COLLATION is the Unicode localization table variants (per country). We used to strip almost everything and add the variants we used in ours builtin collations. User left with the task to ask us for add more or to substitute the DLL. Size of icudt30.dll was around 1,5 MB and 670 KB zipped. With new ICU, I tried to remove most of charsets (we use one from it) and the data we don't use (say, currency, etc). I left all collations variants in it. Size is around 5 MB and 1,5 MB zipped. Is this acceptable? Adriano PS: I feel frustrated to ask this, but... -- Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121054471iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] ICU Data table customization
19.02.2014 16:19, Adriano dos Santos Fernandes wrote: Size of icudt30.dll was around 1,5 MB and 670 KB zipped. With new ICU, I tried to remove most of charsets (we use one from it) and the data we don't use (say, currency, etc). I left all collations variants in it. Size is around 5 MB and 1,5 MB zipped. Is this acceptable? As said Aleksey Kovazin, Internet traffic today is cheap. Why to care about size and strip anything?.. -- WBR, SD. -- Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121054471iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] ICU Data table customization
On Wednesday 19 February 2014 16:19:22 Adriano dos Santos Fernandes wrote: With new ICU, I tried to remove most of charsets (we use one from it) and the data we don't use (say, currency, etc). I left all collations variants in it. Size is around 5 MB and 1,5 MB zipped. Is this acceptable? I don't see any practical alternative. Theoretically we could offer different packages. I would guess that most users only use a small subset of the available characters, but breaking that down into, say, english, western european, easter european, etc would seem to be a lot of work, and difficult to maintain. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -- Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121054471iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] ICU Data table customization
On Wednesday 19 February 2014 16:23:44 Dimitry Sibiryakov wrote: As said Aleksey Kovazin, Internet traffic today is cheap. Why to care about size and strip anything?.. Just because we can doesn't mean we should. :-) Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -- Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121054471iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] ICU Data table customization
Would it be feasible to restructure ICU has a master DLL/shared image plus a DLL/shared image per character set loaded on demand? If so, Firebird could be packaged with a small subset containing popular languages with others available for download somewhere. On 2/19/2014 10:30 AM, Paul Reeves wrote: On Wednesday 19 February 2014 16:19:22 Adriano dos Santos Fernandes wrote: With new ICU, I tried to remove most of charsets (we use one from it) and the data we don't use (say, currency, etc). I left all collations variants in it. Size is around 5 MB and 1,5 MB zipped. Is this acceptable? I don't see any practical alternative. Theoretically we could offer different packages. I would guess that most users only use a small subset of the available characters, but breaking that down into, say, english, western european, easter european, etc would seem to be a lot of work, and difficult to maintain. Paul -- Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121054471iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] ICU Data table customization
On 19/02/2014 12:23, Dimitry Sibiryakov wrote: 19.02.2014 16:19, Adriano dos Santos Fernandes wrote: Size of icudt30.dll was around 1,5 MB and 670 KB zipped. With new ICU, I tried to remove most of charsets (we use one from it) and the data we don't use (say, currency, etc). I left all collations variants in it. Size is around 5 MB and 1,5 MB zipped. Is this acceptable? As said Aleksey Kovazin, Internet traffic today is cheap. Why to care about size and strip anything?.. Are you bipolar? Adriano -- Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121054471iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] ICU Data table customization
19.02.2014 16:48, Adriano dos Santos Fernandes wrote: As said Aleksey Kovazin, Internet traffic today is cheap. Why to care about size and strip anything?.. Are you bipolar? I care about my own traffic only. If I had wanted to save it, I would load stripped ICU (or no ICU at all) because I know what functionality all installed on my HDD applications need from it. AK don't care about traffic, users usually aren't aware of required functionality. To install them stripped ICU and risking to break their system is a bad thing, IMHO. -- WBR, SD. -- Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121054471iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] ICU Data table customization
19.02.2014 19:19, Adriano dos Santos Fernandes wrote: One thing of ICU we use and allows the user to use with CREATE COLLATION is the Unicode localization table variants (per country). We used to strip almost everything and add the variants we used in ours builtin collations. User left with the task to ask us for add more or to substitute the DLL. Size of icudt30.dll was around 1,5 MB and 670 KB zipped. With new ICU, I tried to remove most of charsets (we use one from it) and the data we don't use (say, currency, etc). I left all collations variants in it. Size is around 5 MB and 1,5 MB zipped. Is this acceptable? Absolutely OK, as for me. Dmitry -- Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121054471iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Alpha 2 - Trace Output - Execution of package-based stored procedure
Tried todays snapshot build (Win 32-bit). The output looks like a bit weird regarding package/procedure name: 2014-02-18T21:59:55.1080 (456:00C32D20) EXECUTE_PROCEDURE_FINISH tourism.fdb (ATT_332, TOURISM:NONE, UNICODE_FSS, TCPv4:127.0.0.1) C:\Program Files (x86)\Upscene Productions\Database Workbench 4 Pro\DBW4.exe:4928 (TRA_574, READ_COMMITTED | REC_VERSION | NOWAIT | READ_WRITE) Procedure PKG_SCHE´õŸ: 0 ms Yes, i know. I and already fixed it at my private tree. Will be committed soon with tracing of functions. Good news. Thanks. ;-) Regards, Thomas -- Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121054471iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Alpha 2 - Trace Output - Execution of package-based stored procedure
On 19/02/2014 16:16, Claudio Valderrama C. wrote: -Original Message- From: Adriano dos Santos Fernandes [mailto:adrian...@gmail.com] Sent: Miércoles, 19 de Febrero de 2014 8:10 On 18/02/2014 19:26, Claudio Valderrama C. wrote: Probable because the string created by QualifiedName.toString() goes out of scope before the contents can be copied. While it would be more tedious to use, I would prefer this function changed to string toString(string out) to ensure the result is written in out and not in a temporary object. Then you need to change every routine that returns a string. The problem is not with this function. The problem is where is passing a c_str() of a temporary object. Most objects return a string that's a data member. It doesn't matter if you copy the result or use it directly, unless the object itself is destroyed: ptr = dbb-dbb_filename.c_str() ptr = tdbb-getAttachment()-att_filename.c_str() ptr = work-dfw_name.c_str() ptr = itemInfo-name.c_str() I can use the pointer in a code section until the object is destroyed or the name is changed. I'm not saying that you can use the pointer forever, but at least in a few lines of code after calling it. These are all data members, not functions. QualifiedName.toString() is different because it builds a temporary just to return the result. The concatenated name doesn't exist inside QualifiedName, so the result of c_str is invalid immediately. The simplest code causes a failure ptr = qualifiedName.toString().c_str() And as I said, with any function returning a string (not string). You can still do callFunction(qualifiedName.toString().c_str()), the temporary will be destroyed at the end of the statement. The problem is with code that caches the char* value coming from a string. Adriano -- Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121054471iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4345) Ability to trace stored functions execution
Ability to trace stored functions execution --- Key: CORE-4345 URL: http://tracker.firebirdsql.org/browse/CORE-4345 Project: Firebird Core Issue Type: Improvement Components: Engine Reporter: Vlad Khorsun -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121054471iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Alpha 2 - Trace API - Stored Function support?
will there be or is there already support for stored function execution in the Trace API similar to stored procedures? Sure, it is under development. Thanks for the information. Done, happy testing ;) Regards, Vlad -- Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121054471iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Alpha 2 - Trace Output - Execution of package-based stored procedure
Tried todays snapshot build (Win 32-bit). The output looks like a bit weird regarding package/procedure name: 2014-02-18T21:59:55.1080 (456:00C32D20) EXECUTE_PROCEDURE_FINISH tourism.fdb (ATT_332, TOURISM:NONE, UNICODE_FSS, TCPv4:127.0.0.1) C:\Program Files (x86)\Upscene Productions\Database Workbench 4 Pro\DBW4.exe:4928 (TRA_574, READ_COMMITTED | REC_VERSION | NOWAIT | READ_WRITE) Procedure PKG_SCHE´õŸ: 0 ms Yes, i know. I and already fixed it at my private tree. Will be committed soon with tracing of functions. Good news. Thanks. ;-) Committed, test it please. Regards, Vlad -- Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121054471iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Alpha 2 - Trace API - Stored Function support?
will there be or is there already support for stored function execution in the Trace API similar to stored procedures? Sure, it is under development. Thanks for the information. Done, happy testing ;) Lovely. ;-) Thanks a lot! Will give it a go in the forthcoming days. As well for the package/procedure naming output issue. Thanks again and sleep well. Thomas -- Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121054471iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4346) v3 GBAK cannot restore backups on pre-v3 server versions
v3 GBAK cannot restore backups on pre-v3 server versions Key: CORE-4346 URL: http://tracker.firebirdsql.org/browse/CORE-4346 Project: Firebird Core Issue Type: Bug Components: GBAK Affects Versions: 3.0 Alpha 2, 3.0 Alpha 1 Reporter: Dmitry Yemanov Restore ends with error: gbak: ERROR:invalid request BLR at offset 201 gbak: ERROR:generator RDB$GENERATOR_NAME is not defined gbak:Exiting before completion due to errors -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121054471iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] ICU Data table customization
On 02/19/14 20:11, Dmitry Yemanov wrote: 19.02.2014 19:19, Adriano dos Santos Fernandes wrote: One thing of ICU we use and allows the user to use with CREATE COLLATION is the Unicode localization table variants (per country). We used to strip almost everything and add the variants we used in ours builtin collations. User left with the task to ask us for add more or to substitute the DLL. Size of icudt30.dll was around 1,5 MB and 670 KB zipped. With new ICU, I tried to remove most of charsets (we use one from it) and the data we don't use (say, currency, etc). I left all collations variants in it. Size is around 5 MB and 1,5 MB zipped. Is this acceptable? Absolutely OK, as for me. +1 -- Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121054471iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel