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: Daniel R. <da...@ac...> - 2017-03-08 20:04:41
|
Hi, At March 8, 2017, 3:09 PM, Jiří Činčura wrote: >> Also, what is the timeline to support VS 2017? I tried by simply >> changing the registry keys from 14_Config to 15_Config, but that >> simply created a 15_Config registry key that only contained the >> registry keys for Firebird, and nothing else. It looks like that they >> have changed how the integration works. > Great. Something I don't want to hear. :) Hopefully it's just the > registry keys, not the whole DDEX story. Although I wouldn't mind fresh > API for that, preferably fully managed. > >> I can add the VS2017 support request to the tracker, just let me know >> under which component(s) that would be appropriate. > It' already there under DNET-739. I added a comment to DNET-739 with a link to the breaking changes in VS 2017 with regards to the integration and the registry keys. It looks like that the best approach would be to use the VSIX package installer, possibly using the External Settings Manager. -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) |
|
From: Jiří Č. <ji...@ci...> - 2017-03-08 19:09:34
|
> Also, what is the timeline to support VS 2017? I tried by simply > changing the registry keys from 14_Config to 15_Config, but that > simply created a 15_Config registry key that only contained the > registry keys for Firebird, and nothing else. It looks like that they > have changed how the integration works. Great. Something I don't want to hear. :) Hopefully it's just the registry keys, not the whole DDEX story. Although I wouldn't mind fresh API for that, preferably fully managed. > I can add the VS2017 support request to the tracker, just let me know > under which component(s) that would be appropriate. It' already there under DNET-739. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ |
|
From: Jiří Č. <ji...@ci...> - 2017-03-08 17:28:47
|
Known mistake. Your machine config entry and GAC does not match. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ On Wed, Mar 8, 2017, at 18:28, Paul Dryden wrote: > Hi, > > I was able to get Firebird to show up in the provider list by copying an > <entityframework> setting to my app.config file. I found that setting > somewhere on the web. But that didn't wok either. Whenever I type > anything into an input field, the dialog disappears. Very frustrating. > > > On 3/7/2017 2:12 PM, Daniel Rail wrote: > > Hi all, > > > > I was able to connect in VS2015 and create some classes to represent a > > few tables(from an existing database) by using the "ADO.Net Entity > > Model" template, by using the "Code First from Database". > > > > But, something happened(and I don't know what) that now I can't get > > the Firebird ADO.Net driver to show up in the connection dialog for > > the "ADO.Net Entity Model" template or even to add connections in the > > VS2015 Server Explorer. I reinstalled the Firebird DDEX(3.0.2), and > > even ran the .reg files manually, and the Firebird ADO.Net(5.8.0.0) > > driver but no success. I even checked machine.config and all the > > entries are there. In the project, the Firebird drivers are added via > > NuGet. > > > > Also, this is on the latest version of Windows 10 and VS2015 is up to > > date. > > > > Is there anything else that I need to look at? If more information is > > needed, let me know. > > > > ------------------------------------------------------------------------------ > Announcing the Oxford Dictionaries API! The API offers world-renowned > dictionary content that is easy and intuitive to access. Sign up for an > account today to start using our lexical data to power your apps and > projects. Get started today and enter our developer competition. > http://sdm.link/oxford > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
|
From: Paul D. <pau...@ut...> - 2017-03-08 17:27:56
|
Hi, I was able to get Firebird to show up in the provider list by copying an <entityframework> setting to my app.config file. I found that setting somewhere on the web. But that didn't wok either. Whenever I type anything into an input field, the dialog disappears. Very frustrating. On 3/7/2017 2:12 PM, Daniel Rail wrote: > Hi all, > > I was able to connect in VS2015 and create some classes to represent a > few tables(from an existing database) by using the "ADO.Net Entity > Model" template, by using the "Code First from Database". > > But, something happened(and I don't know what) that now I can't get > the Firebird ADO.Net driver to show up in the connection dialog for > the "ADO.Net Entity Model" template or even to add connections in the > VS2015 Server Explorer. I reinstalled the Firebird DDEX(3.0.2), and > even ran the .reg files manually, and the Firebird ADO.Net(5.8.0.0) > driver but no success. I even checked machine.config and all the > entries are there. In the project, the Firebird drivers are added via > NuGet. > > Also, this is on the latest version of Windows 10 and VS2015 is up to > date. > > Is there anything else that I need to look at? If more information is > needed, let me know. > |
|
From: Daniel R. <da...@ac...> - 2017-03-08 13:16:12
|
Hi, At March 8, 2017, 2:16 AM, Jiří Činčura wrote: > Check whether the registry entries are there (for VS2015). That was the problem. I did double-click on the .reg file and Windows told me that the entries were added, but they were not. I just used the Import function inside RegEdit, and that worked. Also, what is the timeline to support VS 2017? I tried by simply changing the registry keys from 14_Config to 15_Config, but that simply created a 15_Config registry key that only contained the registry keys for Firebird, and nothing else. It looks like that they have changed how the integration works. I can add the VS2017 support request to the tracker, just let me know under which component(s) that would be appropriate. -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) |
|
From: André Z. (J. <tr...@fi...> - 2017-03-08 08:05:05
|
Support Visual Studio 2017
--------------------------
Key: DNET-739
URL: http://tracker.firebirdsql.org/browse/DNET-739
Project: .NET Data provider
Issue Type: Improvement
Components: DDEX Provider
Affects Versions: 5.8.0.0
Environment: Win10 + VS2017
Reporter: André Ziegler
Assignee: Jiri Cincura
Can you please add support for the Visual Studio 2017 to the DDEX Installer? Currently it only supports Vs versions up to VS2015.
--
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...> - 2017-03-08 06:16:20
|
Check whether the registry entries are there (for VS2015). -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ On Tue, Mar 7, 2017, at 22:12, Daniel Rail wrote: > Hi all, > > I was able to connect in VS2015 and create some classes to represent a > few tables(from an existing database) by using the "ADO.Net Entity > Model" template, by using the "Code First from Database". > > But, something happened(and I don't know what) that now I can't get > the Firebird ADO.Net driver to show up in the connection dialog for > the "ADO.Net Entity Model" template or even to add connections in the > VS2015 Server Explorer. I reinstalled the Firebird DDEX(3.0.2), and > even ran the .reg files manually, and the Firebird ADO.Net(5.8.0.0) > driver but no success. I even checked machine.config and all the > entries are there. In the project, the Firebird drivers are added via > NuGet. > > Also, this is on the latest version of Windows 10 and VS2015 is up to > date. > > Is there anything else that I need to look at? If more information is > needed, let me know. > > -- > Best regards, > Daniel Rail > Senior System Engineer > ACCRA Solutions Inc. (www.accra.ca) > ACCRA Med Software Inc. (www.filopto.com) > > > ------------------------------------------------------------------------------ > Announcing the Oxford Dictionaries API! The API offers world-renowned > dictionary content that is easy and intuitive to access. Sign up for an > account today to start using our lexical data to power your apps and > projects. Get started today and enter our developer competition. > http://sdm.link/oxford > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
|
From: Daniel R. <da...@ac...> - 2017-03-07 21:13:03
|
Hi all, I was able to connect in VS2015 and create some classes to represent a few tables(from an existing database) by using the "ADO.Net Entity Model" template, by using the "Code First from Database". But, something happened(and I don't know what) that now I can't get the Firebird ADO.Net driver to show up in the connection dialog for the "ADO.Net Entity Model" template or even to add connections in the VS2015 Server Explorer. I reinstalled the Firebird DDEX(3.0.2), and even ran the .reg files manually, and the Firebird ADO.Net(5.8.0.0) driver but no success. I even checked machine.config and all the entries are there. In the project, the Firebird drivers are added via NuGet. Also, this is on the latest version of Windows 10 and VS2015 is up to date. Is there anything else that I need to look at? If more information is needed, let me know. -- Best regards, Daniel Rail Senior System Engineer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) |
|
From: Jiří Č. <ji...@ci...> - 2017-03-01 15:14:31
|
Do you really have to detach? Wouldn't work for you just fine to set the state to unchanged (nor sure what's done with the entities after)? Other than that, I believe putting it into list/array is OK (at least for me). You might even just use ToList method and foreach on that, without the extra variable - but the intermediate list will be created anyway, so it's just a cosmetic thing. -- Mgr. Jiří Činčura https://blog.cincura.net/ |
|
From: Nikolaus K. <par...@gm...> - 2017-03-01 14:41:38
|
Hello, I am currently using EF 6.x with Firebird 2.5.x and it works very well. During a dataload from an external datasource I load a number of records from my database and compare them with the external source. Sometimes I have to correct/complete my data. In the case this update fails on the database i detach the current entity that the following updates can continue. This works fine unless I have modified a navigation property of the current entity. List<RESSOURCEN> = this.RESSOURCEN.Where(a => a.RESSOURCEN_STATUS == "Aktiv").Include(b => b.ARBEITSZEITEN).ToList(); // I loop through the List<RESSOURCEN> // I modify one of the navigation properties ARBEITSZEITEN // The update fails this._efContext.Entry(res).State = EntityState.Detached; // Now the entity RESSOURCEN res is detached and all navigation properties are set to null. I understand the reason for that, following this page: http://stackoverflow.com/questions/10342445/why-does-setting-entitystate-to- detached-empty-a-property-of-type-listt#10343174 // I tried to detach the navigation property before the entity itself, but this fails: Change of items in the enumeration I am currently looping through. Foreach(ARBEITSZEITEN azneu in res.ARBEITSZEITEN) { this._efContext.Entry(azneu) State = EntityState.Detached; } // I added now the modified navigation properties to my own list, which I use then the detach. modifiedAZ.Add(az); // In the case of a error during update on the database Foreach(ARBEITSZEITEN azneu in modifiedAZ) { this._efContext.Entry(azneu) State = EntityState.Detached; } modifiedAZ.Clear(); How would you handle such a situation? Thanks Niko |
|
From: Jiří Č. <ji...@ci...> - 2017-02-25 07:11:10
|
> if ((_csManager?.Role.Length ?? 0) != 0) > spb.Append((byte)IscCodes.isc_spb_sql_role_name, _csManager.Role); > > That being said, it doesn't seem to have an effect and even if logged in > with role RDB$ADMIN, only the given user is returned (other than if > SYSDBA). > > Thoughts? Is there any way to list the users? > > If not, can it be added as a features that if logged in with RDB$ADMIN > role, that the users can be listed? Sure. But do your work and find what needs to be changed. Maybe the role needs to be passed in other place and not only in SPB. -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: David C. <wav...@gm...> - 2017-02-24 21:39:50
|
Hi Jiri, I also posted on the Firebird Yahoo group, and received an informative response that from what the person looked at, they wrote that it seemed that the .NET Provider does not use the ROLE when connecting. When I dig into the .NET Provider source, specifically the FbSecurity.DisplayUsers() call, I see that the call to FbService.Open() in turn calls FbService.BuildSpb() which does seem to set the ROLE if given (FbService.cs, line 98): if ((_csManager?.Role.Length ?? 0) != 0) spb.Append((byte)IscCodes.isc_spb_sql_role_name, _csManager.Role); That being said, it doesn't seem to have an effect and even if logged in with role RDB$ADMIN, only the given user is returned (other than if SYSDBA). Thoughts? Is there any way to list the users? If not, can it be added as a features that if logged in with RDB$ADMIN role, that the users can be listed? Thanks, David On 24 February 2017 at 01:13, Jiří Činčura <ji...@ci...> wrote: > > This is different from how things work in gsec. There, enumeration of > > users > > IS possible by connecting via the RDB$ADMIN role; > > >gsec -user MyAdm -pass admpw -role rdb$admin -display > > This gsec command is not connecting to remote database using services > API. > > -- > Mgr. Jiří Činčura > Independent IT Specialist > > ------------------------------------------------------------ > ------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > |
|
From: Jiří Č. <ji...@ci...> - 2017-02-24 09:13:24
|
> This is different from how things work in gsec. There, enumeration of > users > IS possible by connecting via the RDB$ADMIN role; > >gsec -user MyAdm -pass admpw -role rdb$admin -display This gsec command is not connecting to remote database using services API. -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: David C. <wav...@gm...> - 2017-02-23 23:02:45
|
When I am trying to use some of the FirebirdSql.Data.Services API (v5.6)
against a Firebird v2.5.6 database, such as;
- FirebirdSql.Data.Services.FbServerProperties.GetDatabasesInfo()
- FirebirdSql.Data.Services.FbSecurity.GetUsersDbPath()
I get the error:
"Service isc_info_svc_svr_db_info requires SYSDBA permissions. Reattach to
the Service Manager using the SYSDBA account."
This is even though I am logged in under the RDB$ADMIN ROLE.
More to the point, further, when I call
FbUserData[] users = Globals.FbSecurity.DisplayUsers();
(NB: Where my Globals.FbSecurity returns a FirebirdSql.Data.Services.FbSecurity
object)
I am provided with the full list of users when logged in as SYSDBA, but if
logged in as another user under the RDB$ADMIN ROLE, I am returned only this
given user in FbUserData[].
This is different from how things work in gsec. There, enumeration of users
IS possible by connecting via the RDB$ADMIN role;
>gsec -user MyAdm -pass admpw -role rdb$admin -display
As I can CREATE and DROP users under a user with the RDB$ADMIN ROLE, it
seems strange that I cannot list them as well.
Is there any way of accessing the services API under a user other than
SYSDBA? More to the point, I want to create users who have administrative
function on the database (ie CREATE/DROP users) so that the SYSDBA user
(and its password) are not in use/shared. But I need to be able to
enumerate the list of users (eg FbSecurity.DisplayUsers()).
Thanks in advance,
David
[image: Inline images 1]
|
|
From: Jiří Č. <ji...@ci...> - 2017-02-23 15:20:56
|
More info: http://blog.cincura.net/233594-ado-net-provider-5-8-0-0-for-firebird-is-ready/ . -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Berko B. <vb...@ma...> - 2017-02-23 10:52:24
|
My Delphi Code:
db.Open;
Query.Transaction.StartTransaction;
d1:=now;
Query.SQL.Text:='select i0,c1,f1,f2,f3,f4 from test';
Query.Open;
while not Query.Eof do
begin
if (Query.FieldByName('I0').AsInteger<0) or
(Query.FieldByName('C1').AsString='???') or
(Query.FieldByName('F1').AsString='???') or
(Query.FieldByName('F2').AsString='???') or
(Query.FieldByName('F3').AsString='???') or
(Query.FieldByName('F4').AsString='???') then Caption:='ok';
Query.Next;
end;
d2:=now;
showmessage(inttostr(Query.RecordCount)+':'+inttostr(MilliSecondsBetween(d2,d1)));
Tran.Commit;
|
|
From: Jiří Č. <ji...@ci...> - 2017-02-23 10:04:05
|
How the Delphi code looks like? -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Berko B. <vb...@ma...> - 2017-02-23 09:43:41
|
> > I feel, the number of records (or number of varchar columns) grows, so > > does the difference between C# and Delphi. > > You feel or can you confirm it? Did you tried i.e. selecting just NULL? I set null the F1-F5 fields, i get test result: C# : ~ 110 ms Delphi: ~ 50 ms So the difference between C# and Delphi decrease. Berko |
|
From: Jiří Č. <ji...@ci...> - 2017-02-23 08:32:03
|
> I feel, the number of records (or number of varchar columns) grows, so > does the difference between C# and Delphi. You feel or can you confirm it? Did you tried i.e. selecting just NULL? -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Berko B. <vb...@ma...> - 2017-02-23 08:26:09
|
Hi,
I terrible sorry of previous mail format. I try it again in plain text.
I have a problem with performance of firebird net provider.
My query is slow.
In my table there are ~ 5000 records.
Simple query: select * from table
In case of IBExpert or Delphi program, it takes ~ 80 ms
In case of C# ~ 250 ms
I fetch all records in IBExpert and Delphi too.
I have tried on local database and on networking db. No Difference.
My environment:
- Windows 7 64.
- Firebird Superserver 2.5.7
- Net provider 5.7
I feel, the number of records (or number of varchar columns) grows, so does the difference between C# and Delphi.
My DB Script:
------------------
SET SQL DIALECT 3;
CREATE DATABASE '127.0.0.1:c:\test\test.fdb'
USER 'user' PASSWORD 'password'
PAGE_SIZE 8192;
CREATE TABLE TEST (
I0 INTEGER NOT NULL,
C1 CHAR(10),
F1 VARCHAR(120),
F2 VARCHAR(120),
F3 VARCHAR(120),
F4 VARCHAR(120)
);
COMMIT WORK;
ALTER TABLE TEST ADD CONSTRAINT PK_TEST PRIMARY KEY (I0);
commit work;
set term ^ ;
execute block
as
declare variable i integer;
declare variable par varchar(120);
begin
i=1;
par='aaaaaaaaaaaaaaaaaaaaxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxyyyyyyyyyyyyyyyyyyyyHHHHHHHHHH';
while (i<5000) do
begin
insert into test(i0,c1,f1,f2,f3,f4) values (:i,trim(cast(:i as varchar(5)))||'_ID',:par, :par,:par, :par);
i=i+1;
end
end^
set term ; ^
commit work;
C# program:
------------------
string cs =
@"User = user; Password=password;Database=c:\test\test.fdb;DataSource=127.0.0.1"
+ ";Port=3050;Dialect=3;Role=;Connection lifetime = 15; "
+ "Pooling=false;Packet Size = 8192; ServerType=0;";
var con = new FbConnection(cs);
con.Open();
var watch = System.Diagnostics.Stopwatch.StartNew();
FbCommand com = new FbCommand("select i0,c1,f1,f2,f3,f4 from test", con);
var dr = com.ExecuteReader();
while (dr.Read()) ;
watch.Stop();
var elapsedMs = watch.ElapsedMilliseconds;
Console.WriteLine(elapsedMs.ToString());
com.Dispose();
con.Dispose();
|
|
From: Berko B. <vb...@ma...> - 2017-02-23 08:16:20
|
<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div> <div>Hi,</div> <div>I have a problem with performance of firebird net provider.</div> <div>My query is slow.</div> <div>In my table there are ~ 5000 records.</div> <div>Simple query: select * from table</div> <div> </div> <div>In case of IBExpert or Delphi program, it takes ~ 80 ms</div> <div>In case of C# ~ 250 ms</div> <div>I fetch all records in IBExpert and Delphi too.</div> <div>I have tried on local database and on networking db. No Difference.</div> <div>My environment:</div> <div>- Windows 7 64.</div> <div>- Firebird Superserver 2.5.7</div> <div>- Net provider 5.7</div> <div> </div> <div>I feel, the number of records (or number of varchar columns) grows, so does the difference between C# and Delphi.</div> <div> </div> <div>My DB Script:</div> <div>------------------</div> <div> <div>SET SQL DIALECT 3;</div> <div>CREATE DATABASE '127.0.0.1:c:\test\test.fdb'<br/> USER 'user' PASSWORD 'password'<br/> PAGE_SIZE 8192;</div> <div><br/> CREATE TABLE TEST (<br/> I0 INTEGER NOT NULL,<br/> C1 CHAR(10),<br/> F1 VARCHAR(120),<br/> F2 VARCHAR(120),<br/> F3 VARCHAR(120),<br/> F4 VARCHAR(120)<br/> );<br/> COMMIT WORK;<br/> ALTER TABLE TEST ADD CONSTRAINT PK_TEST PRIMARY KEY (I0);<br/> commit work;<br/> set term ^ ;<br/> execute block<br/> as<br/> declare variable i integer;<br/> declare variable par varchar(120);<br/> begin<br/> i=1;<br/> par='aaaaaaaaaaaaaaaaaaaaxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxyyyyyyyyyyyyyyyyyyyyHHHHHHHHHH';<br/> while (i<5000) do<br/> begin<br/> insert into test(i0,c1,f1,f2,f3,f4) values (:i,trim(cast(:i as varchar(5)))||'_ID',:par, :par,:par, :par);<br/> i=i+1;<br/> end</div> <div>end^<br/> set term ; ^</div> <div>commit work;</div> </div> <div> </div> <div>C# program:</div> <div>------------------</div> <div> <div> string cs =<br/> @"User = user; Password=password;Database=c:\test\test.fdb;DataSource=127.0.0.1"<br/> + ";Port=3050;Dialect=3;Role=;Connection lifetime = 15; "<br/> + "Pooling=false;Packet Size = 8192; ServerType=0;";</div> <div> var con = new FbConnection(cs);<br/> con.Open();<br/> var watch = System.Diagnostics.Stopwatch.StartNew();<br/> FbCommand com = new FbCommand("select i0,c1,f1,f2,f3,f4 from test", con);<br/> var dr = com.ExecuteReader();<br/> while (dr.Read()) ;<br/> watch.Stop();<br/> var elapsedMs = watch.ElapsedMilliseconds;<br/> Console.WriteLine(elapsedMs.ToString());<br/> com.Dispose();<br/> con.Dispose();</div> <div> </div> </div> </div></div></body></html> |
|
From: Nicolas T. <nft...@ho...> - 2017-02-21 12:39:59
|
Excuse me, Yes I tried to search I do not know why I did not find this part of the code, but thank you very much for having spent your time and for having responded with this part this is very useful for me and my company, With regard to the part of tidying up my code I do not understand the reason and maybe you could clarify to me, because I have applications in SQL Server and MySQL of which they do not need too, and in these the provider seems to do this operation, what would be the reason of not changing Does the provider already do this? What would be the impact? -----Mensagem original----- De: Jiří Činčura [mailto:ji...@ci...] Enviada em: terça-feira, 21 de fevereiro de 2017 09:31 Para: For users and developers of the Firebird .NET providers <fir...@li...> Assunto: Re: [Firebird-net-provider] RES: CORE4563 > But I'm thinking of upgrading to version 5.7 but I no longer find the > part of the code, Did you at least try to grep the sources? It's like one second operation and easy result. It's in https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/blob/master/Provider/src/FirebirdSql.Data.FirebirdClient/Client/Managed/Version10/GdsStatement.cs#L778 . > Is very important this change because I have no feasibility to change > the whole system where the parameters are passed to put the size of > the field, is there a solution to this? I would strongly advice you to fix your code, instead of band-aiding sources. Your hack is very dangerous and you will eventually loose data. -- Mgr. Jiří Činčura Independent IT Specialist ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
|
From: Jiří Č. <ji...@ci...> - 2017-02-21 12:31:35
|
> But I'm thinking of upgrading to version 5.7 but I no longer find the > part of the code, Did you at least try to grep the sources? It's like one second operation and easy result. It's in https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/blob/master/Provider/src/FirebirdSql.Data.FirebirdClient/Client/Managed/Version10/GdsStatement.cs#L778 . > Is very important this change because I have no feasibility to change the > whole system where the parameters are passed to put the size of the > field, is there a solution to this? I would strongly advice you to fix your code, instead of band-aiding sources. Your hack is very dangerous and you will eventually loose data. -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Nicolas T. <nft...@ho...> - 2017-02-21 12:24:30
|
Hello,
In the version of provider 4.10 we made a change to prevent the error of "Arithmetic overflow string truncation"
What I did was the following I accessed the file "XdrStream.cs",
I was looking for this part of the code
Throw new IscException (new [] {IscCodes.isc_arith_except, IscCodes.isc_string_truncation});
And I applied a "substring"
Svalue = svalue.Substring (0, param.CharCount);
But I'm thinking of upgrading to version 5.7 but I no longer find the part of the code,
Is very important this change because I have no feasibility to change the whole system where the parameters are passed to put the size of the field, is there a solution to this?
-----Mensagem original-----
De: Jiří Činčura [mailto:ji...@ci...]
Enviada em: segunda-feira, 20 de fevereiro de 2017 18:01
Para: fir...@li...
Assunto: Re: [Firebird-net-provider] CORE4563
It's linked to that ticket:
http://tracker.firebirdsql.org/browse/DNET-726 .
--
Mgr. Jiří Činčura
Independent IT Specialist
On Mon, Feb 20, 2017, at 19:40, Nicolas Timmers wrote:
> Hello everyone
>
> With the release of version 2.5.7, we have the item
>
> Http://tracker.firebirdsql.org/browse/CORE-4563
>
> Has been implemented, I would like to know if you will need
> modifications to .net provider?
> ----------------------------------------------------------------------
> -------- Check out the vibrant tech community on one of the world's
> most engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot _______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
|
|
From: Nicolas T. <nft...@ho...> - 2017-02-21 11:29:49
|
tanks -----Mensagem original----- De: Jiří Činčura [mailto:ji...@ci...] Enviada em: segunda-feira, 20 de fevereiro de 2017 18:01 Para: fir...@li... Assunto: Re: [Firebird-net-provider] CORE4563 It's linked to that ticket: http://tracker.firebirdsql.org/browse/DNET-726 . -- Mgr. Jiří Činčura Independent IT Specialist On Mon, Feb 20, 2017, at 19:40, Nicolas Timmers wrote: > Hello everyone > > With the release of version 2.5.7, we have the item > > Http://tracker.firebirdsql.org/browse/CORE-4563 > > Has been implemented, I would like to know if you will need > modifications to .net provider? > ---------------------------------------------------------------------- > -------- Check out the vibrant tech community on one of the world's > most engaging tech sites, SlashDot.org! http://sdm.link/slashdot > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
211 messages has been excluded from this view by a project administrator.
