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: Jar J. B. (JIRA) <tr...@fi...> - 2014-12-03 09:38:38
|
Need Dialect 1 Support in Entity Framework 6.x
----------------------------------------------
Key: DNET-580
URL: http://tracker.firebirdsql.org/browse/DNET-580
Project: .NET Data provider
Issue Type: New Feature
Components: Entity Framework support
Affects Versions: 4.5.2.0
Reporter: Jar Jar Binks
Assignee: Jiri Cincura
I need Dialect 1 Support for the Entity Framework 6.x.
I have create a new Fork to implement this feature, But it is implemented with preprocessor directives. I don't found a point to switch it at runtime.
--
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: Toni M. (JIRA) <tr...@fi...> - 2014-12-02 18:21:52
|
Reading lot of string values from database (fetching string values) performance is poor
---------------------------------------------------------------------------------------
Key: DNET-579
URL: http://tracker.firebirdsql.org/browse/DNET-579
Project: .NET Data provider
Issue Type: Improvement
Components: ADO.NET Provider
Affects Versions: 4.5.0.0
Environment: Any
Reporter: Toni Martir
Assignee: Jiri Cincura
When fetching rows, reading string column values calls public static Charset GetCharset(string charsetName)
Replacing the sequential search with a dictionary there is a 80% performance gain when reading strings:
private static Dictionary<string, Charset> supportedCharsetsNames;
public static Charset GetCharset(string charsetName)
{
return supportedCharsetsNames[charsetName];
}
And inside InitializeSupportedCharsets:
supportedCharsetsNames = new Dictionary<string, Charset>();
foreach (Charset ncharset in charsets)
{
supportedCharsetsNames.Add(ncharset.name, ncharset);
}
--
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: Paul D. <paul.dryden@m.cc.utah.edu> - 2014-12-01 00:19:32
|
I have several computers that I manage where I can produce and edmx file from a firebird database without problem. However, my main development computer isn't working as it should. I can start a project in VS, then add new item, data, entity data framework. The firebird connection capability is present and I can point to a database, then I am show the database objects. I selected the tables, then next button. But what is produced is basically an empty edmx file, it has the different sections but no data about the database.
I have tried to set this Windows 7 machine up like one of the machines that is working using three configuration items:
1) gac entry:
FirebirdSql.Data.FirebirdClient, Version=4.5.0.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c, processorArchitecture=MSIL
2)Framework machine.config entry:
<system.data>
<DbProviderFactories>
<add name="FirebirdClient Data Provider" invariant="FirebirdSql.Data.FirebirdClient" description=".NET Framework Data Provider for Firebird" type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient, Version=4.5.0.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c"/></DbProviderFactories>
</system.data>
3) Registry data
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VisualStudio\10.0\DataProviders\{92421248-F044-483A-8237-74C7FBC62971} and
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VisualStudio\10.0\DataSources\{2979569E-416D-4DD8-B06B-EBCB70DE7A4E} match on both computers.
Can anyone suggest a way to track this down? I got so frustrated that I rebuilt the dev machine and set it up as described above, but to no avail. Is there a package missing in my VS2010?
pablo en Utah
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2014-11-27 11:50:52
|
For [VAR]CHAR constants use real length if there's none from facet
------------------------------------------------------------------
Key: DNET-578
URL: http://tracker.firebirdsql.org/browse/DNET-578
Project: .NET Data provider
Issue Type: Improvement
Components: Entity Framework support
Affects Versions: 4.5.2.0
Reporter: Jiri Cincura
Assignee: Jiri Cincura
Priority: Minor
--
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: Joseph M. <jo...@jm...> - 2014-11-26 17:38:13
|
Thanks guys. I changed the character set to ISO8859_1, and everything works great now! -Joe On Wed, Nov 26, 2014 at 3:09 AM, Hernán Martínez < her...@ob...> wrote: > www.destructor.de/firebird/charsets.htm > > Hernán MF S > > El 26/11/2014, a las 5:04, Joseph Martinez <jo...@jm...> > escribió: > > Ok, I was able to dump it into a file. From the auto-detection that I ran > it through, it looks like it's either ISO-8859-1 or Windows-1252. > > What exact strings would I put in my connection string to use one of those? > > Here's my original line of code: > > entityBuilder.ProviderConnectionString = > string.Format("character set=NONE;data source={0};initial catalog={1};;user > id={2};password={3};isolationlevel=ReadCommitted", connparams.server, > connparams.path, connparams.userid, connparams.password); > > If I replace "NONE" with "ISO-8859-1" or "Windows-1252", I get an > exception saying: > > The underlying provider failed on Open. > Invalid character set specified > > Is there a list of valid character set constants that it will accept? > > -Joe > > > On Tue, Nov 25, 2014 at 11:26 PM, Jiří Činčura <ji...@ci...> wrote: > >> Study http://www.firebirdsql.org/refdocs/langrefupd25.html . >> >> -- >> Mgr. Jiří Činčura >> Independent IT Specialist >> >> ------------------------------------------------------------------------------ >> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server >> from Actuate! Instantly Supercharge Your Business Reports and Dashboards >> with Interactivity, Sharing, Native Excel Exports, App Integration & more >> Get technology previously reserved for billion-dollar corporations, FREE >> >> http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk >> _______________________________________________ >> Firebird-net-provider mailing list >> Fir...@li... >> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider >> > > > ------------------------------------------------------------------------------ > Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server > from Actuate! Instantly Supercharge Your Business Reports and Dashboards > with Interactivity, Sharing, Native Excel Exports, App Integration & more > Get technology previously reserved for billion-dollar corporations, FREE > > http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk > > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > > > ------------------------------------------------------------------------------ > Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server > from Actuate! Instantly Supercharge Your Business Reports and Dashboards > with Interactivity, Sharing, Native Excel Exports, App Integration & more > Get technology previously reserved for billion-dollar corporations, FREE > > http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > |
|
From: Hernán M. <her...@ob...> - 2014-11-26 11:33:01
|
www.destructor.de/firebird/charsets.htm Hernán MF S > El 26/11/2014, a las 5:04, Joseph Martinez <jo...@jm...> escribió: > > Ok, I was able to dump it into a file. From the auto-detection that I ran it through, it looks like it's either ISO-8859-1 or Windows-1252. > > What exact strings would I put in my connection string to use one of those? > > Here's my original line of code: > > entityBuilder.ProviderConnectionString = string.Format("character set=NONE;data source={0};initial catalog={1};;user id={2};password={3};isolationlevel=ReadCommitted", connparams.server, connparams.path, connparams.userid, connparams.password); > > If I replace "NONE" with "ISO-8859-1" or "Windows-1252", I get an exception saying: > > The underlying provider failed on Open. > Invalid character set specified > > Is there a list of valid character set constants that it will accept? > > -Joe > > >> On Tue, Nov 25, 2014 at 11:26 PM, Jiří Činčura <ji...@ci...> wrote: >> Study http://www.firebirdsql.org/refdocs/langrefupd25.html . >> >> -- >> Mgr. Jiří Činčura >> Independent IT Specialist >> ------------------------------------------------------------------------------ >> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server >> from Actuate! Instantly Supercharge Your Business Reports and Dashboards >> with Interactivity, Sharing, Native Excel Exports, App Integration & more >> Get technology previously reserved for billion-dollar corporations, FREE >> http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk >> _______________________________________________ >> Firebird-net-provider mailing list >> Fir...@li... >> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > ------------------------------------------------------------------------------ > Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server > from Actuate! Instantly Supercharge Your Business Reports and Dashboards > with Interactivity, Sharing, Native Excel Exports, App Integration & more > Get technology previously reserved for billion-dollar corporations, FREE > http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
|
From: Joseph M. <jo...@jm...> - 2014-11-26 08:04:50
|
Ok, I was able to dump it into a file. From the auto-detection that I ran
it through, it looks like it's either ISO-8859-1 or Windows-1252.
What exact strings would I put in my connection string to use one of those?
Here's my original line of code:
entityBuilder.ProviderConnectionString =
string.Format("character set=NONE;data source={0};initial catalog={1};;user
id={2};password={3};isolationlevel=ReadCommitted", connparams.server,
connparams.path, connparams.userid, connparams.password);
If I replace "NONE" with "ISO-8859-1" or "Windows-1252", I get an exception
saying:
The underlying provider failed on Open.
Invalid character set specified
Is there a list of valid character set constants that it will accept?
-Joe
On Tue, Nov 25, 2014 at 11:26 PM, Jiří Činčura <ji...@ci...> wrote:
> Study http://www.firebirdsql.org/refdocs/langrefupd25.html .
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
> ------------------------------------------------------------------------------
> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
> from Actuate! Instantly Supercharge Your Business Reports and Dashboards
> with Interactivity, Sharing, Native Excel Exports, App Integration & more
> Get technology previously reserved for billion-dollar corporations, FREE
>
> http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
|
|
From: Jiří Č. <ji...@ci...> - 2014-11-26 07:26:30
|
Study http://www.firebirdsql.org/refdocs/langrefupd25.html . -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Joseph M. <jo...@jm...> - 2014-11-26 07:22:13
|
I am not experienced with ISQL. Do you have an example of a command that would output the value of a VARCHAR field as hex? -Joe On Tue, Nov 25, 2014 at 11:06 PM, Jiří Činčura <ji...@ci...> wrote: > isql > > -- > Mgr. Jiří Činčura > Independent IT Specialist > > > ------------------------------------------------------------------------------ > Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server > from Actuate! Instantly Supercharge Your Business Reports and Dashboards > with Interactivity, Sharing, Native Excel Exports, App Integration & more > Get technology previously reserved for billion-dollar corporations, FREE > > http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > |
|
From: Jiří Č. <ji...@ci...> - 2014-11-26 07:06:43
|
isql -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Joseph M. <jo...@jm...> - 2014-11-26 07:00:01
|
What tool could I use to dump it from the database in hex to a file? -Joe On Tue, Nov 25, 2014 at 10:44 PM, Jiří Činčura <ji...@ci...> wrote: > Absolutely. Put there some text. Dump it in hex to file. Open it in some > “smart” editor – a lot of editors have a feature to guess encoding. > > You can also do it to with encoding tables. But that’s manual and slow. :) > > -- > Mgr. Jiří Činčura > Independent IT Specialist > > ------------------------------------------------------------------------------ > Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server > from Actuate! Instantly Supercharge Your Business Reports and Dashboards > with Interactivity, Sharing, Native Excel Exports, App Integration & more > Get technology previously reserved for billion-dollar corporations, FREE > > http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > |
|
From: Jiří Č. <ji...@ci...> - 2014-11-26 06:44:23
|
Absolutely. Put there some text. Dump it in hex to file. Open it in some “smart” editor – a lot of editors have a feature to guess encoding. You can also do it to with encoding tables. But that’s manual and slow. :) -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Joseph M. <jo...@jm...> - 2014-11-26 06:40:49
|
Would there be a way to deduce the character that is being used by the C++ application by putting certain characters in, and then somehow examining what is actually stored in the database? -Joe On Tue, Nov 25, 2014 at 10:25 PM, Jiří Činčura <ji...@ci...> wrote: > Hard to say what charset the C++ is actually using. But using NONE on > database was *very* bad choice. The encoding might be pretty screwed in. > Use UTF8 in .NET, but I expect you’re going to do manual transliteration > because of NONE charset used. > > -- > Mgr. Jiří Činčura > Independent IT Specialist > > > ------------------------------------------------------------------------------ > Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server > from Actuate! Instantly Supercharge Your Business Reports and Dashboards > with Interactivity, Sharing, Native Excel Exports, App Integration & more > Get technology previously reserved for billion-dollar corporations, FREE > > http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > |
|
From: Jiří Č. <ji...@ci...> - 2014-11-26 06:26:01
|
Hard to say what charset the C++ is actually using. But using NONE on database was *very* bad choice. The encoding might be pretty screwed in. Use UTF8 in .NET, but I expect you’re going to do manual transliteration because of NONE charset used. -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Joseph M. <jo...@jm...> - 2014-11-26 05:46:19
|
The database was created with character set of "NONE". In my C++/IBObjects project, the CharSet is Null. In my .NET project, the connection string has the character set as "NONE". So what wouldn't be matching? I can't really change the database or the C++ project at this point. Too many users with many years of data stored the way it is now. What can I change in my .NET project to fix the issue that I'm having? -Joe On Tue, Nov 25, 2014 at 9:17 PM, Jiří Činčura <ji...@ci...> wrote: > You have very likely mismatch in charsets. To prevent it, basically, just > use UTF8, everywhere. > > -- > Mgr. Jiří Činčura > Independent IT Specialist > > > ------------------------------------------------------------------------------ > Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server > from Actuate! Instantly Supercharge Your Business Reports and Dashboards > with Interactivity, Sharing, Native Excel Exports, App Integration & more > Get technology previously reserved for billion-dollar corporations, FREE > > http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > |
|
From: Jiří Č. <ji...@ci...> - 2014-11-26 05:18:04
|
You have very likely mismatch in charsets. To prevent it, basically, just use UTF8, everywhere. -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Joseph M. <jo...@jm...> - 2014-11-25 23:15:47
|
I'm having a strange problem. When special symbols are stored in my database, if the record is edited, it gets written back to the database as a different symbol or several symbols. Here's an example: I have a Firebird application that uses C++ and IBObjects. If I enter or paste into a database field some text containing the Trademark symbol ™ (typed alt-0153. Bytes are e2 84 a2), it shows correctly in the database, on the screen, etc. Now, if I access the same database record using .NET, the Firebird .NET provider, and Entity Framework, and edit that record, even if I don't modify the field containing the trademark symbol, when I save the record, it writes the trademark symbol back as: â„¢ (bytes are c3 a2 e2 80 9e c2 a2). Here is the code that I'm using: PRODUCT p = db.PRODUCTS.FirstOrDefault<PRODUCT>(pp => pp.PRODBARCODE == ecp.PRODBARCODE && pp.STOREID == _storeid); p.PRODWEBDIRTY = "F"; db.Entry(p).State = EntityState.Modified; db.SaveChanges(); Note that PRODWEBDIRTY is not the field containing the trademark symbol. I guess it's just writing back the entire record to the database, but with the special characters converted. Why does it do this? How can I prevent it? -Joe |
|
From: Pascal (JIRA) <tr...@fi...> - 2014-11-24 09:34:19
|
The utilisation of parameters writes in the standard output so the performances are considerably descreased
-----------------------------------------------------------------------------------------------------------
Key: DNET-577
URL: http://tracker.firebirdsql.org/browse/DNET-577
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 4.5.2.0
Environment: Client application runs on a Windows 7 64 bits with FirebirdSql.Data.FirebirdClient.dll 4.5.2.0 (also tested with 2.7.5.0 and there's the same issue).
Firebird 2.1.4.18393 (Win32) on a Windows Server 2003 SP2 64 bits.
Reporter: Pascal
Assignee: Jiri Cincura
Priority: Blocker
To insert datas in a Firebird database, I use a FbCommand with parameters and transactions to be as quick as possible.
But the FbCommand writes in the standard ouput all values of all parameters. So when with anoter database the job lasts one hour, with Firebird it lasts ten hours.
It's very important for me to get a fix and I can't go to production with this low performances.
The code is made to work with SQL Server, Oracle, MySQL, PostgreSQL and Firebird.
This is an example of code to reproduce:
public void InsererEnregistrement(string nomTable)
{
const IsolationLevel isolationLevel = IsolationLevel.ReadUncommitted;
const int nbreLigneTotal = 1000;
var parametres = new List<string>();
for (int i = 1; i <= 50; i++)
parametres.Add("@p" + i);
var commande = String.Format("INSERT INTO {0} VALUES (" + parametres.Aggregate((a, b) => a + ", " + b) + ")", nomTable);
using (var connexion = new FbConnection())
{
connexion.ConnectionString = ConnectionStringBuilder.ConnectionString;
connexion.Open();
using (var command = new FbCommand())
{
command.Connection = connexion;
command.CommandText = commande;
DbTransaction transaction = connexion.BeginTransaction(isolationLevel);
command.Transaction = transaction;
for (int i = 1; i <= 25; i++)
{
var parametre = new FbParameter();
parametre.ParameterName = "@p" + i;
parametre.DbType = DbType.Int32;
command.Parameters.Add(parametre);
}
for (int i = 26; i <= 50; i++)
{
var parametre = new FbParameter();
parametre.ParameterName = "@p" + i;
parametre.DbType = DbType.String;
command.Parameters.Add(parametre);
}
command.Prepare();
for (int i = 0; i <= nbreLigneTotal; i++)
{
command.Parameters[0].Value = (i + 1) * 100000;
command.Parameters[1].Value = i;
command.Parameters[2].Value = 0;
for (int j = 4; j <= 25; j++)
command.Parameters[j - 1].Value = 1234567890;
for (int j = 26; j <= 50; j++)
command.Parameters[j - 1].Value = "01234657890123456789012345678901234567890123456789";
command.ExecuteNonQuery();
if ((i != 0) && ((i % 1000) == 0))
{
transaction.Commit();
if (i != nbreLigneTotal)
{
transaction = connexion.BeginTransaction(isolationLevel);
command.Transaction = transaction;
}
}
}
}
}
}
And for each row inserted, I got this in the standard output :
FirebirdSql.Data.FirebirdClient Information: 0 : Command:
INSERT INTO SMR8_MODIF_C50T50L0100000 VALUES (@p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15, @p16, @p17, @p18, @p19, @p20, @p21, @p22, @p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35, @p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47, @p48, @p49, @p50)
Parameters:
Name:@p1 Type:Integer Used Value:100000
Name:@p2 Type:Integer Used Value:0
Name:@p3 Type:Integer Used Value:0
Name:@p4 Type:Integer Used Value:1234567890
Name:@p5 Type:Integer Used Value:1234567890
Name:@p6 Type:Integer Used Value:1234567890
Name:@p7 Type:Integer Used Value:1234567890
Name:@p8 Type:Integer Used Value:1234567890
Name:@p9 Type:Integer Used Value:1234567890
Name:@p10 Type:Integer Used Value:1234567890
Name:@p11 Type:Integer Used Value:1234567890
Name:@p12 Type:Integer Used Value:1234567890
Name:@p13 Type:Integer Used Value:1234567890
Name:@p14 Type:Integer Used Value:1234567890
Name:@p15 Type:Integer Used Value:1234567890
Name:@p16 Type:Integer Used Value:1234567890
Name:@p17 Type:Integer Used Value:1234567890
Name:@p18 Type:Integer Used Value:1234567890
Name:@p19 Type:Integer Used Value:1234567890
Name:@p20 Type:Integer Used Value:1234567890
Name:@p21 Type:Integer Used Value:1234567890
Name:@p22 Type:Integer Used Value:1234567890
Name:@p23 Type:Integer Used Value:1234567890
Name:@p24 Type:Integer Used Value:1234567890
Name:@p25 Type:Integer Used Value:1234567890
Name:@p26 Type:VarChar Used Value:01234657890123456789012345678901234567890123456789
Name:@p27 Type:VarChar Used Value:01234657890123456789012345678901234567890123456789
Name:@p28 Type:VarChar Used Value:01234657890123456789012345678901234567890123456789
Name:@p29 Type:VarChar Used Value:01234657890123456789012345678901234567890123456789
Name:@p30 Type:VarChar Used Value:01234657890123456789012345678901234567890123456789
Name:@p31 Type:VarChar Used Value:01234657890123456789012345678901234567890123456789
Name:@p32 Type:VarChar Used Value:01234657890123456789012345678901234567890123456789
Name:@p33 Type:VarChar Used Value:01234657890123456789012345678901234567890123456789
Name:@p34 Type:VarChar Used Value:01234657890123456789012345678901234567890123456789
Name:@p35 Type:VarChar Used Value:01234657890123456789012345678901234567890123456789
Name:@p36 Type:VarChar Used Value:01234657890123456789012345678901234567890123456789
Name:@p37 Type:VarChar Used Value:01234657890123456789012345678901234567890123456789
Name:@p38 Type:VarChar Used Value:01234657890123456789012345678901234567890123456789
Name:@p39 Type:VarChar Used Value:01234657890123456789012345678901234567890123456789
Name:@p40 Type:VarChar Used Value:01234657890123456789012345678901234567890123456789
Name:@p41 Type:VarChar Used Value:01234657890123456789012345678901234567890123456789
Name:@p42 Type:VarChar Used Value:01234657890123456789012345678901234567890123456789
Name:@p43 Type:VarChar Used Value:01234657890123456789012345678901234567890123456789
Name:@p44 Type:VarChar Used Value:01234657890123456789012345678901234567890123456789
Name:@p45 Type:VarChar Used Value:01234657890123456789012345678901234567890123456789
Name:@p46 Type:VarChar Used Value:01234657890123456789012345678901234567890123456789
Name:@p47 Type:VarChar Used Value:01234657890123456789012345678901234567890123456789
Name:@p48 Type:VarChar Used Value:01234657890123456789012345678901234567890123456789
Name:@p49 Type:VarChar Used Value:01234657890123456789012345678901234567890123456789
Name:@p50 Type:VarChar Used Value:01234657890123456789012345678901234567890123456789
If you think, it's important to continue to write parameters in the standard output, you can put in the setup the bin/release dll without writing and the bin/debug dll with writing.
So the developpers can use the release or the debug version depending of their needs.
Regards,
--
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: Геннадий З. <zab...@gm...> - 2014-11-13 17:11:41
|
Don't have enough time to merge and test it. I look forward to test it and write some feedback on next week. 2014-11-13 18:31 GMT+02:00 Jiří Činčura <ji...@ci...>: > Except for "identity" generation should be "done": http://ge.tt/3OSvoR42 . > > Some feedback? > > -- > Mgr. Jiří Činčura > Independent IT Specialist > > > ------------------------------------------------------------------------------ > Comprehensive Server Monitoring with Site24x7. > Monitor 10 servers for $9/Month. > Get alerted through email, SMS, voice calls or mobile push notifications. > Take corrective actions from your mobile device. > > http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > |
|
From: Jiří Č. <ji...@ci...> - 2014-11-13 16:32:10
|
Except for "identity" generation should be "done": http://ge.tt/3OSvoR42 . Some feedback? -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Jiri C. (JIRA) <tr...@fi...> - 2014-11-13 08:01:32
|
IPv6 support
------------
Key: DNET-576
URL: http://tracker.firebirdsql.org/browse/DNET-576
Project: .NET Data provider
Issue Type: Task
Components: ADO.NET Provider
Affects Versions: 4.5.2.0
Reporter: Jiri Cincura
Assignee: Jiri Cincura
Priority: Minor
--
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...> - 2014-11-11 14:03:27
|
ClearPool is not using NormalizedConnectionString
-------------------------------------------------
Key: DNET-575
URL: http://tracker.firebirdsql.org/browse/DNET-575
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 4.5.2.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...> - 2014-11-11 08:33:36
|
> Exactly. I'm currently planning to investigate whether EF allows adding 3rd > party services/interfaces to be resolved. And how clean that looks like. OK, so this is not a way. Not only the "resolver" is not acessible it's also DbConfiguration related not DbMigrationsConfiguration. Maybe it's good idea to have FbMigrationSqlGenerator with interface parameter like IFbIdentityGenerator in ctor for handling identities and use default one when no such is provided. -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Jiří Č. <ji...@ci...> - 2014-11-11 08:03:58
|
And BTW does anybody has some detailed information about "Although this form of EXECUTE STATEMENT can also be used with all kinds of DDL strings (except CREATE/DROP DATABASE), it is generally very, very unwise to use this trick in order to circumvent the no-DDL rule in PSQL.", which I'm using to drop NOT NULL constraint? I know it's generally wrong, but any problems on engine's side? -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Jiří Č. <ji...@ci...> - 2014-11-11 07:11:36
|
So anybody tested migrations? -- Mgr. Jiří Činčura Independent IT Specialist |
211 messages has been excluded from this view by a project administrator.
