Menu
▾
▴
firebird-net-provider — All about development of the MS .Net provider
You can subscribe to this list here.
| 2002 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(10) |
Nov
(55) |
Dec
(36) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2003 |
Jan
(38) |
Feb
(108) |
Mar
(79) |
Apr
(95) |
May
(64) |
Jun
(130) |
Jul
(146) |
Aug
(121) |
Sep
(96) |
Oct
(149) |
Nov
(161) |
Dec
(113) |
| 2004 |
Jan
(113) |
Feb
(163) |
Mar
(248) |
Apr
(132) |
May
(157) |
Jun
(160) |
Jul
(236) |
Aug
(284) |
Sep
(293) |
Oct
(277) |
Nov
(257) |
Dec
(356) |
| 2005 |
Jan
(203) |
Feb
(190) |
Mar
(220) |
Apr
(165) |
May
(124) |
Jun
(160) |
Jul
(190) |
Aug
(142) |
Sep
(152) |
Oct
(189) |
Nov
(187) |
Dec
(159) |
| 2006 |
Jan
(170) |
Feb
(151) |
Mar
(212) |
Apr
(262) |
May
(226) |
Jun
(196) |
Jul
(223) |
Aug
(165) |
Sep
(163) |
Oct
(348) |
Nov
(225) |
Dec
(141) |
| 2007 |
Jan
(261) |
Feb
(161) |
Mar
(222) |
Apr
(193) |
May
(121) |
Jun
(157) |
Jul
(151) |
Aug
(159) |
Sep
(61) |
Oct
(123) |
Nov
(172) |
Dec
(96) |
| 2008 |
Jan
(104) |
Feb
(138) |
Mar
(131) |
Apr
(131) |
May
(74) |
Jun
(107) |
Jul
(89) |
Aug
(89) |
Sep
(172) |
Oct
(158) |
Nov
(119) |
Dec
(86) |
| 2009 |
Jan
(52) |
Feb
(84) |
Mar
(78) |
Apr
(83) |
May
(54) |
Jun
(79) |
Jul
(60) |
Aug
(62) |
Sep
(50) |
Oct
(147) |
Nov
(50) |
Dec
(70) |
| 2010 |
Jan
(135) |
Feb
(113) |
Mar
(74) |
Apr
(93) |
May
(35) |
Jun
(71) |
Jul
(33) |
Aug
(110) |
Sep
(47) |
Oct
(18) |
Nov
(61) |
Dec
(34) |
| 2011 |
Jan
(46) |
Feb
(47) |
Mar
(25) |
Apr
(24) |
May
(21) |
Jun
(22) |
Jul
(20) |
Aug
(51) |
Sep
(31) |
Oct
(42) |
Nov
(22) |
Dec
(22) |
| 2012 |
Jan
(31) |
Feb
(19) |
Mar
(25) |
Apr
(55) |
May
(16) |
Jun
(28) |
Jul
(33) |
Aug
(25) |
Sep
(32) |
Oct
(25) |
Nov
(52) |
Dec
(35) |
| 2013 |
Jan
(43) |
Feb
(18) |
Mar
(36) |
Apr
(45) |
May
(22) |
Jun
(13) |
Jul
(31) |
Aug
(24) |
Sep
(19) |
Oct
(59) |
Nov
(47) |
Dec
(25) |
| 2014 |
Jan
(27) |
Feb
(15) |
Mar
(38) |
Apr
(10) |
May
(15) |
Jun
(36) |
Jul
(24) |
Aug
(28) |
Sep
(16) |
Oct
(6) |
Nov
(44) |
Dec
(40) |
| 2015 |
Jan
(52) |
Feb
(22) |
Mar
(13) |
Apr
(17) |
May
(22) |
Jun
(36) |
Jul
(18) |
Aug
(41) |
Sep
(71) |
Oct
(60) |
Nov
(49) |
Dec
(43) |
| 2016 |
Jan
(60) |
Feb
(13) |
Mar
(21) |
Apr
(28) |
May
(23) |
Jun
(39) |
Jul
(17) |
Aug
(37) |
Sep
(33) |
Oct
(15) |
Nov
(22) |
Dec
(20) |
| 2017 |
Jan
(27) |
Feb
(40) |
Mar
(48) |
Apr
(19) |
May
(29) |
Jun
(2) |
Jul
(19) |
Aug
(36) |
Sep
(18) |
Oct
(10) |
Nov
(11) |
Dec
(5) |
| 2018 |
Jan
(5) |
Feb
(4) |
Mar
(5) |
Apr
(3) |
May
(4) |
Jun
(17) |
Jul
(7) |
Aug
(7) |
Sep
(12) |
Oct
(8) |
Nov
(2) |
Dec
|
| 2019 |
Jan
(8) |
Feb
(5) |
Mar
(3) |
Apr
(5) |
May
(3) |
Jun
(2) |
Jul
(8) |
Aug
(7) |
Sep
(3) |
Oct
(12) |
Nov
(7) |
Dec
(1) |
| 2020 |
Jan
(8) |
Feb
(3) |
Mar
(7) |
Apr
(1) |
May
(2) |
Jun
(1) |
Jul
(3) |
Aug
(25) |
Sep
(5) |
Oct
(3) |
Nov
(7) |
Dec
(16) |
| 2021 |
Jan
(11) |
Feb
(10) |
Mar
(16) |
Apr
(8) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Jiří Č. <ji...@ci...> - 2015-08-29 16:28:21
|
Also if you have some feedback you can discuss it here ahead of time. No problem with that. -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Jiří Č. <ji...@ci...> - 2015-08-29 16:26:52
|
> Can it be merged to master and released as Beta so this won't be used by everybody? Probably. It would be nice to know when EF6.2 will go out, so we know how long is going to be in beta state. For me it doesn't make much sense to have it in beta for say 5+ months. -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Геннадий З. <zab...@gm...> - 2015-08-29 16:25:27
|
Can it be merged to master and released as Beta so this won't be used by everybody? On Saturday, 29 August 2015, Jiří Činčura <ji...@ci...> wrote: > I do. > > > > I’m still waiting for EF 6.2 as it contains some fixes we need for proper > error reporting. It’s already fixed in sources, but not yet released. It > works but people would complain and given how much stupid questions I get > about DDEX, I’m not going to do that. > > > > -- > > Mgr. Jiří Činčura > > Independent IT Specialist > > > > *From:* Геннадий Забула [mailto:zab...@gm... > <javascript:_e(%7B%7D,'cvml','zab...@gm...');>] > *Sent:* Saturday, August 29, 2015 5:18 PM > *To:* For users and developers of the Firebird .NET providers < > fir...@li... > <javascript:_e(%7B%7D,'cvml','fir...@li...');> > > > *Subject:* [Firebird-net-provider] Migrations > > > > What is the current status of migrations? Last change was 8 month. Do you > plan to merge it to master? > > We are using branch for almost half year in our project and can give some > feedback/fixes. And want to port them to upstream. > |
|
From: Геннадий З. <zab...@gm...> - 2015-08-29 16:22:27
|
Can it be merged to master and released as Beta so this won't be used by everybody? On Saturday, 29 August 2015, Jiří Činčura <ji...@ci...> wrote: > I do. > > > > I’m still waiting for EF 6.2 as it contains some fixes we need for proper > error reporting. It’s already fixed in sources, but not yet released. It > works but people would complain and given how much stupid questions I get > about DDEX, I’m not going to do that. > > > > -- > > Mgr. Jiří Činčura > > Independent IT Specialist > > > > *From:* Геннадий Забула [mailto:zab...@gm... > <javascript:_e(%7B%7D,'cvml','zab...@gm...');>] > *Sent:* Saturday, August 29, 2015 5:18 PM > *To:* For users and developers of the Firebird .NET providers < > fir...@li... > <javascript:_e(%7B%7D,'cvml','fir...@li...');> > > > *Subject:* [Firebird-net-provider] Migrations > > > > What is the current status of migrations? Last change was 8 month. Do you > plan to merge it to master? > > We are using branch for almost half year in our project and can give some > feedback/fixes. And want to port them to upstream. > |
|
From: Jiří Č. <ji...@ci...> - 2015-08-29 16:17:07
|
This error you'll get when the server version you're using does not support this feature. It was introduced in 2.5.3 I think and 2.5.2 would not cut it. -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Jiří Č. <ji...@ci...> - 2015-08-29 16:14:53
|
I do. I’m still waiting for EF 6.2 as it contains some fixes we need for proper error reporting. It’s already fixed in sources, but not yet released. It works but people would complain and given how much stupid questions I get about DDEX, I’m not going to do that. -- Mgr. Jiří Činčura Independent IT Specialist From: Геннадий Забула [mailto:zab...@gm...] Sent: Saturday, August 29, 2015 5:18 PM To: For users and developers of the Firebird .NET providers <fir...@li...> Subject: [Firebird-net-provider] Migrations What is the current status of migrations? Last change was 8 month. Do you plan to merge it to master? We are using branch for almost half year in our project and can give some feedback/fixes. And want to port them to upstream. |
|
From: Parzival <par...@gm...> - 2015-08-29 15:36:32
|
Hello, the database is at the moment on the same pc. When I have mastered the art of local backup I will move to the remote servers as well. Niko Von: Геннадий Забула [mailto:zab...@gm...] Gesendet: Samstag, 29. August 2015 17:04 An: For users and developers of the Firebird .NET providers <fir...@li...> Betreff: Re: [Firebird-net-provider] fbstreambackup: "free disk space exhausted" I'm not sure, but can you check disk space on the remote server where database is placed? On Saturday, 29 August 2015, Parzival <par...@gm... <mailto:par...@gm...> > wrote: Hallo, I try to move from calling gbak as an external tool for backup and use fbstreambackup instead. Unfortunatly I get an error message "free disk space exhausted", which is confusing. The disk has enough space to store the backup file. For that reason I am guessing that there is something wrong with the way I call the backup. This is the code (in vulcan.net <http://vulcan.net> ): // declare variables LOCAL fsb AS FbStreamingBackup LOCAL fs AS System.IO.FileStream // create new backup fsb := FbStreamingBackup{ sb:ToString() } fs := System.IO.FileStream{"D:\temp\test.gbk", FileMode.Create } fsb:OutputStream := fs fsb:Execute() // It fails here Can please somebody point out what I am missing here? Maybe the filestream is not correct assign to FbStreamingBackup… Thanks Niko |
|
From: Геннадий З. <zab...@gm...> - 2015-08-29 15:18:10
|
What is the current status of migrations? Last change was 8 month. Do you plan to merge it to master? We are using branch for almost half year in our project and can give some feedback/fixes. And want to port them to upstream. |
|
From: Геннадий З. <zab...@gm...> - 2015-08-29 15:04:12
|
I'm not sure, but can you check disk space on the remote server where database is placed? On Saturday, 29 August 2015, Parzival <par...@gm...> wrote: > Hallo, > > > > I try to move from calling gbak as an external tool for backup and use > fbstreambackup instead. > > > > Unfortunatly I get an error message "free disk space exhausted", which is > confusing. The disk has enough space to store the backup file. For that > reason I am guessing that there is something wrong with the way I call the > backup. > > > > This is the code (in vulcan.net): > > > > // declare variables > > LOCAL fsb AS FbStreamingBackup > > LOCAL fs AS System.IO.FileStream > > > > // create new backup > > fsb := FbStreamingBackup{ sb:ToString() } > > fs := System.IO.FileStream{"D:\temp\test.gbk", FileMode.Create } > > fsb:OutputStream := fs > > > > fsb:Execute() // It fails here > > > > Can please somebody point out what I am missing here? Maybe the filestream > is not correct assign to FbStreamingBackup… > > > > Thanks > > > > Niko > |
|
From: Parzival <par...@gm...> - 2015-08-29 14:49:57
|
Hallo, I try to move from calling gbak as an external tool for backup and use fbstreambackup instead. Unfortunatly I get an error message "free disk space exhausted", which is confusing. The disk has enough space to store the backup file. For that reason I am guessing that there is something wrong with the way I call the backup. This is the code (in vulcan.net): // declare variables LOCAL fsb AS FbStreamingBackup LOCAL fs AS System.IO.FileStream // create new backup fsb := FbStreamingBackup{ sb:ToString() } fs := System.IO.FileStream{"D:\temp\test.gbk", FileMode.Create } fsb:OutputStream := fs fsb:Execute() // It fails here Can please somebody point out what I am missing here? Maybe the filestream is not correct assign to FbStreamingBackup. Thanks Niko |
|
From: Jiří Č. <ji...@ci...> - 2015-08-27 04:58:51
|
> One more question about string.Equals. Comparison type used in IndexOf > calls is StringComparison.CurrentCultureIgnoreCase. My question why this > used instead of OrdinalIgnoreCase? > My current optimization, including StringComparison change decreased > timings to 22 (names) vs 6 (indexes) seconds. Because of national characters. Somebody might use these in parameter name. Although it's pretty weird, I had similar issue in DDEX. -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Jiří Č. <ji...@ci...> - 2015-08-27 04:54:38
|
Yes, the FindIndex was dominant for me as well. I like the idea with parameterName[0]. -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Геннадий З. <zab...@gm...> - 2015-08-26 19:03:07
|
One more question about string.Equals. Comparison type used in IndexOf
calls is StringComparison.CurrentCultureIgnoreCase. My question why
this used instead of OrdinalIgnoreCase?
My current optimization, including StringComparison change decreased
timings to 22 (names) vs 6 (indexes) seconds.
On 26 August 2015 at 20:33, Геннадий Забула <zab...@gm...> wrote:
> About Equals call I'm not sure it can be optimized somehow.
> But decreasing cost of NormalizeParameterName should significantly
> reduce overall case execution time.
>
> On 26 August 2015 at 20:27, Геннадий Забула <zab...@gm...> wrote:
>> I've profiled case and found out next hot paths:
>>
>> get_Item: 54,56%
>> 1. 30.30%
>> return this.parameters.FindIndex((Predicate<FbParameter>) (x =>
>> x.InternalParameterName.Equals(normalizedParameterName,
>> StringComparison.CurrentCultureIgnoreCase)));
>> Equals call
>> 2. 21,51%
>> internal static string NormalizeParameterName(string parameterName)
>> {
>> if (string.IsNullOrEmpty(parameterName) || parameterName.StartsWith("@"))
>> return parameterName;
>> return string.Format("@{0}", (object) parameterName);
>> }
>> This method also can be optmized.
>> StartsWith -> parameterName[0] == '@'
>> string.Format -> string.Concat("@", parameterName)
>>
>> On 26 August 2015 at 16:45, Jiří Činčura <ji...@ci...> wrote:
>>>> Can you share profiler report?
>>>
>>> There's a test app attached to the ticket. It clearly shows the hot spot. I can share only times (from my machine).
>>>
>>> --
>>> Mgr. Jiří Činčura
>>> Independent IT Specialist
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> _______________________________________________
>>> Firebird-net-provider mailing list
>>> Fir...@li...
>>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
|
|
From: Геннадий З. <zab...@gm...> - 2015-08-26 17:33:33
|
About Equals call I'm not sure it can be optimized somehow.
But decreasing cost of NormalizeParameterName should significantly
reduce overall case execution time.
On 26 August 2015 at 20:27, Геннадий Забула <zab...@gm...> wrote:
> I've profiled case and found out next hot paths:
>
> get_Item: 54,56%
> 1. 30.30%
> return this.parameters.FindIndex((Predicate<FbParameter>) (x =>
> x.InternalParameterName.Equals(normalizedParameterName,
> StringComparison.CurrentCultureIgnoreCase)));
> Equals call
> 2. 21,51%
> internal static string NormalizeParameterName(string parameterName)
> {
> if (string.IsNullOrEmpty(parameterName) || parameterName.StartsWith("@"))
> return parameterName;
> return string.Format("@{0}", (object) parameterName);
> }
> This method also can be optmized.
> StartsWith -> parameterName[0] == '@'
> string.Format -> string.Concat("@", parameterName)
>
> On 26 August 2015 at 16:45, Jiří Činčura <ji...@ci...> wrote:
>>> Can you share profiler report?
>>
>> There's a test app attached to the ticket. It clearly shows the hot spot. I can share only times (from my machine).
>>
>> --
>> Mgr. Jiří Činčura
>> Independent IT Specialist
>>
>>
>> ------------------------------------------------------------------------------
>> _______________________________________________
>> Firebird-net-provider mailing list
>> Fir...@li...
>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
|
|
From: Геннадий З. <zab...@gm...> - 2015-08-26 17:27:09
|
I've profiled case and found out next hot paths:
get_Item: 54,56%
1. 30.30%
return this.parameters.FindIndex((Predicate<FbParameter>) (x =>
x.InternalParameterName.Equals(normalizedParameterName,
StringComparison.CurrentCultureIgnoreCase)));
Equals call
2. 21,51%
internal static string NormalizeParameterName(string parameterName)
{
if (string.IsNullOrEmpty(parameterName) || parameterName.StartsWith("@"))
return parameterName;
return string.Format("@{0}", (object) parameterName);
}
This method also can be optmized.
StartsWith -> parameterName[0] == '@'
string.Format -> string.Concat("@", parameterName)
On 26 August 2015 at 16:45, Jiří Činčura <ji...@ci...> wrote:
>> Can you share profiler report?
>
> There's a test app attached to the ticket. It clearly shows the hot spot. I can share only times (from my machine).
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
|
|
From: Jiří Č. <ji...@ci...> - 2015-08-26 13:45:24
|
> Can you share profiler report? There's a test app attached to the ticket. It clearly shows the hot spot. I can share only times (from my machine). -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Геннадий З. <zab...@gm...> - 2015-08-26 13:10:34
|
Can you share profiler report? On 26 August 2015 at 16:05, Jiří Činčura <ji...@ci...> wrote: >> Before doing any optimizations, there should be done some profiling to >> find hot paths in particular cases. >> I think need to start with sample that demonstrates the issue. After that >> start running it in a loop under profiler. > > Done that already. > > -- > Mgr. Jiří Činčura > Independent IT Specialist > > > ------------------------------------------------------------------------------ > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
|
From: Jiří Č. <ji...@ci...> - 2015-08-26 13:05:23
|
> Before doing any optimizations, there should be done some profiling to > find hot paths in particular cases. > I think need to start with sample that demonstrates the issue. After that > start running it in a loop under profiler. Done that already. -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Геннадий З. <zab...@gm...> - 2015-08-26 13:04:30
|
Before doing any optimizations, there should be done some profiling to find hot paths in particular cases. I think need to start with sample that demonstrates the issue. After that start running it in a loop under profiler. On 26 August 2015 at 15:39, Jiří Činčura <ji...@ci...> wrote: > Hi *, > > May I bring to your attention the http://tracker.firebirdsql.org/browse/DNET-532 ? I'd like to know others' view as well. > > -- > Mgr. Jiří Činčura > Independent IT Specialist > > ------------------------------------------------------------------------------ > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
|
From: Jiri C. (JIRA) <tr...@fi...> - 2015-08-26 12:47:17
|
FbServerConfig immutable class
------------------------------
Key: DNET-626
URL: http://tracker.firebirdsql.org/browse/DNET-626
Project: .NET Data provider
Issue Type: Improvement
Components: ADO.NET Provider
Affects Versions: 4.7.0.0
Reporter: Jiri Cincura
Assignee: Jiri Cincura
--
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
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2015-08-26 12:41:13
|
FbDatabasesInfo immutable class
-------------------------------
Key: DNET-625
URL: http://tracker.firebirdsql.org/browse/DNET-625
Project: .NET Data provider
Issue Type: Improvement
Components: ADO.NET Provider
Affects Versions: 4.7.0.0
Reporter: Jiri Cincura
Assignee: Jiri Cincura
--
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
|
|
From: Jiří Č. <ji...@ci...> - 2015-08-26 12:40:07
|
Hi *, May I bring to your attention the http://tracker.firebirdsql.org/browse/DNET-532 ? I'd like to know others' view as well. -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Jiří Č. <ji...@ci...> - 2015-08-25 08:40:05
|
Objections in https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/pull/32 for next 24 hours. ;) Then I'll merge it. -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Ivan A. <int...@un...> - 2015-08-23 16:02:11
|
Hi, It seems to me to be mostly a matter of perspective - those 'units' should be small enough not to make a difference at runtime. Personally, I prefer to keep small stuff as a struct, unless it offers functionality, but .net doesn't really run on hw ancient enough for anyone to notice in those cases :) 2015-08-23 18:49 GMT+03:00 Jiří Činčura <ji...@ci...>: > Hi *, > > Anybody feels like giving me reason why not to make FbTransactionOptions, > FbDatabasesInfo and FbServerConfig classes? I don't see a single reason to > have struct here. In fact quite contrary. OK, maybe the > FbTransactionOptions could make it. > > -- > Mgr. Jiří Činčura > Independent IT Specialist > > > ------------------------------------------------------------------------------ > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > |
|
From: Jiří Č. <ji...@ci...> - 2015-08-23 15:49:53
|
Hi *, Anybody feels like giving me reason why not to make FbTransactionOptions, FbDatabasesInfo and FbServerConfig classes? I don't see a single reason to have struct here. In fact quite contrary. OK, maybe the FbTransactionOptions could make it. -- Mgr. Jiří Činčura Independent IT Specialist |
211 messages has been excluded from this view by a project administrator.
