[Firebird-net-provider] [FB-Tracker] Created: (DNET-1042) Performance regression between 7.10.1 and 8.0.1
Performance regression between 7.10.1 and 8.0.1 --- Key: DNET-1042 URL: http://tracker.firebirdsql.org/browse/DNET-1042 Project: .NET Data provider Issue Type: Bug Components: ADO.NET Provider Affects Versions: 8.0.1.0 Environment: Win10, FB 3.0.7 Reporter: Rand Random Assignee: Jiri Cincura The performance to read data dropped to half between 7.10.1 and 8.0.1. On 7.10.1 my test finishes with 11.14 s. On 8.0.1 my test finishes with 28.72 s. I have created this github project with the code demonstrating my issue https://github.com/Rand-Random/FbPerf Only this file contains code: https://github.com/Rand-Random/FbPerf/blob/main/FbPerf8/FbPerfTest.cs This *.cs file reads 1 million rows from a database containing 5 million records. You can find the used database 7-zipped as TESTPERF.7z in the root of the github project, the file FbPerfTest.cs also contains code how I created/filled the test database, in case it is relevent. The C# project FbPerf7 has the NuGet package for 7.10.1, while the C# project FbPerf8 has the NuGet package version 8.0.1. I am using BenchmarkDotNet for the performance tests, I added the results as images into the root of the github project. The perf7.jpg contains the result for the FbPerf7 C# project, and the perf8.jpg for the FbPerf8 C# project. Please be aware of the fact that the folder FbPerf7 only contains the *.csproj file and not a single *.cs file, this is because I am linking existing files from the FbPerf8 folder, I do this to avoid writing the test twice. -- 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 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] [FB-Tracker] Created: (DNET-1008) String concat - db index
String concat - db index
Key: DNET-1008
URL: http://tracker.firebirdsql.org/browse/DNET-1008
Project: .NET Data provider
Issue Type: Bug
Components: Entity Framework
Affects Versions: 7.10.1.0
Reporter: Rand Random
Assignee: Jiri Cincura
Is it possible to disable in EF provider to parse eg. StartsWith method like
this
WHERE "f"."ITEM1" IS NOT NULL AND (("f"."ITEM1" LIKE _UTF8'HelloWorld' ||
_UTF8'%') AND (LEFT("f"."ITEM1", CHARACTER_LENGTH(_UTF8'HelloWorld')) =
_UTF8'HelloWorld'))
but instead to not concat the '%' character eg.
WHERE "f"."ITEM1" IS NOT NULL AND (("f"."ITEM1" LIKE _UTF8'HelloWorld%') AND
(LEFT("f"."ITEM1", CHARACTER_LENGTH(_UTF8'HelloWorld')) = _UTF8'HelloWorld'))
The first query won't use the index of the database, which is a performance
lose.
I know there are the options
WithExplicitStringLiteralTypes
WithExplicitParameterTypes
which I have marked as false, so I was wondering if there maybe something
similar for my case somewhere hidden.
If there isn't a configuration available already, I would like to ask if
someone could point me in the right direction to make the necessary changes in
the EF provider.
I need to query a rather big table, and not using the index isn't an option,
since the performance drops drastically.
I know I could manually write the "optimized" query myself and use
var foos = context.Foos.FromSqlRaw("SELECT * FROM Foos where Item like
'HelloWorld%'").ToList();
insead of
var foos = context.Foos.Where(x => x.Items.StartsWith("HelloWorld")).ToList();
But I am - currently - not writing those queries my self but rather rely on the
filter mechanism of controls eg. DataGrid, FilterEditor.
Even if there is a solution that "intercepts" the query before sending it to
the database, where I foolishly could write
sqlQuery = sqlQuery.("' || _UTF8'%'", "%'");
would also already be enough for my case.
--
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
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] [FB-Tracker] Created: (DNET-763) Starting with 5.6.0.0 - FBConfiguration doesnt work with special characters (Ä/Ö/Ü/ß)
Starting with 5.6.0.0 - FBConfiguration doesnt work with special characters (Ä/Ö/Ü/ß) - Key: DNET-763 URL: http://tracker.firebirdsql.org/browse/DNET-763 Project: .NET Data provider Issue Type: Bug Components: ADO.NET Provider Affects Versions: 5.9.1.0, 5.9.0.0, 5.8.1.0, 5.8.0.0, 5.7.0.0, 5.6.0.0 Environment: Firebird 2.5 Reporter: Rand Random Assignee: Jiri Cincura The following code fails: var x = new FbConfiguration(GetConnectionString()); x.DatabaseShutdown2(FbShutdownOnlineMode.Single, FbShutdownType.ForceShutdown, 0); with the exception: "I/O error during \"CreateFile (open)\" operation for file \"C:\\TEST\\DüEMO.CONX\"\r\nError while trying to open file" ConnectionString is this: port number=3050;character set=UTF8;initial catalog=C:\\rfa\\Düemo.conx;data source=localhost;user id=x;password=x;pooling=False" In earlier versions this code works fine, addtionionally the normal "FbConnection" works fine with the given Connection string and I can retrieve data just fine. -- 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 -- 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] [FB-Tracker] Created: (DNET-627) Named Instance cannot connect
Named Instance cannot connect
-
Key: DNET-627
URL: http://tracker.firebirdsql.org/browse/DNET-627
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 4.7.0.0
Environment: Win7 - 4.7.0.0 - Firebird 2.5
Reporter: Rand Random
Assignee: Jiri Cincura
I have installed a named instance with the following command
(Notice that before executing this command I already had firebird server
installed, so I now have a default instance and a named, access to the default
still works fine but it fails to connect to named instance)
"C:\Program Files\Firebird\Firebird_2_5\\bin\instsvc" install -name XYZ <--
installs firebird with the named instance
"sc" start "FirebirdServerCONNEX" <-- starts the service
and now I try to connect to this instance with .NET Provider but it fails with
the following exception:
Unable to complete network request to host "localhost/CONNEX"
Am I doing something wrong or is there a problem?
My FbConnectionStringBuilder looks like this:
return new FbConnectionStringBuilder
{
Charset = "UTF8",
Database = "C:\Test\foo.fdb",
DataSource = "localhost/XYZ",
UserID = "SYSDBA",
Password = "masterkey",
}.ToString();
Hope you can help me out.
--
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
--
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991=/4140
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] [FB-Tracker] Created: (DNET-617) NullReferenceException
NullReferenceException -- Key: DNET-617 URL: http://tracker.firebirdsql.org/browse/DNET-617 Project: .NET Data provider Issue Type: Bug Affects Versions: 4.6.4.0 Environment: Win7, Newest FB .Net Provider Reporter: Rand Random Assignee: Jiri Cincura I updated to the latest version of FB .Net Provider. And I am getting NullReferenceException with the following stacktrace bei FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.Write(Int32 value) in c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version10\GdsDatabase.cs:Zeile 1002. (Yes its only this line) -- 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 -- Monitor 25 network devices or servers for free with OpManager! OpManager is web-based network management software that monitors network devices and physical virtual servers, alerts via email sms for fault. Monitor 25 devices for free with no restriction. Download now http://ad.doubleclick.net/ddm/clk/292181274;119417398;o ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] [FB-Tracker] Created: (DNET-557) Cannot create new Model from DataBase
Cannot create new Model from DataBase - Key: DNET-557 URL: http://tracker.firebirdsql.org/browse/DNET-557 Project: .NET Data provider Issue Type: Bug Components: ADO.NET Provider, Entity Framework support Affects Versions: 4.2.0.0 Environment: Win 7, EF 6.1.1, Firebird 2.5, .Net Provider 4.2.0.0 Reporter: Rand Random Assignee: Jiri Cincura I am in the middle of the Add Entity Model to your Project on the page where you would choose your tables, stored procedure and stuff. Sadly I cannot pick a thing because I am getting the following message: An error occured while connecting to the database. The database might be unavailable. An exception of type 'System.Data.Entity.Core.EntityCommandCompilationException' occured. The error message is: 'An error occured while preparing the command definition. See the inner exception for details. The inner exception caught was of type 'System.Data.Entity.Core.MappingException', with this error message: 'StoreSchemaMappingVersion3(3,4): error 3027: No mapping specified for the following EntitySet/AssociationSet - FunctionReturnTableColumns, FunctionFunctionReturnTableColumns'.'. If you need further Information pls say so, thx for your time and help. -- 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 -- Open source business process management suite built on Java and Eclipse Turn processes into business applications with Bonita BPM Community Edition Quickly connect people, data, and systems into organized workflows Winner of BOSSIE, CODIE, OW2 and Gartner awards http://p.sf.net/sfu/Bonitasoft ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] [FB-Tracker] Created: (DNET-526) SqlFunctions
SqlFunctions - Key: DNET-526 URL: http://tracker.firebirdsql.org/browse/DNET-526 Project: .NET Data provider Issue Type: Improvement Components: ADO.NET Provider Environment: Win 7 - .Net Provider 3.2.0.0 - EF6 Reporter: Rand Random Assignee: Jiri Cincura Hi. Pls have a look at the following url: https://entityframework.codeplex.com/workitem/1774 Is there such an implementation in Firebird .Net Provider? -- 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 -- October Webinars: Code for Performance Free Intel webinars can help you accelerate application performance. Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from the latest Intel processors and coprocessors. See abstracts and register http://pubads.g.doubleclick.net/gampad/clk?id=60135991iu=/4140/ostg.clktrk ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] [FB-Tracker] Created: (DNET-518) Implementation limit exceeded
Implementation limit exceeded
---
Key: DNET-518
URL: http://tracker.firebirdsql.org/browse/DNET-518
Project: .NET Data provider
Issue Type: Bug
Environment: Win7 x64 - VS 2012 - Firebird 2.5.x - .Net Provider
3.1.1.0
Reporter: Rand Random
Assignee: Jiri Cincura
I am still facing the issue when I want to update my EDMX Model, as described
here
http://tracker.firebirdsql.org/browse/DNET-513
http://tracker.firebirdsql.org/browse/DNET-514
Just to make sure I am using the version 3.1.1.0 I did the following in my code:
using (var conx = new EntityModel())
{
var bla = conx.TabAccounts.Where(x = x.AccNr ==
1001).Single();
}
Which sucessfully run, and outputed to this sql query:
SELECT FIRST (2)
B.IDACCOUNT AS IDACCOUNT,
B.IDCOMPANY AS IDCOMPANY,
B.IDPARENT AS IDPARENT,
B.ACCNR AS ACCNR,
B.ACCNRSUB AS ACCNRSUB,
B.FLAGISSPLIT AS FLAGISSPLIT,
B.FLAGISSYSTEMACCOUNT AS FLAGISSYSTEMACCOUNT,
B.TEXTACCOUNTGL AS TEXTACCOUNTGL
FROM TABACCOUNT AS B
WHERE CAST(_UTF8'1001' AS VARCHAR(8191)) = B.ACCNR
As you notice the VARCHAR(8191) is fixed, but on Update Model from Database it
fails.
Also I would like to mention that the .Single method here gets parsed to
SELECT FIRST (2) shouldnt it be SELECT FIRST (1)... ?
Hope you can help me out.
--
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
--
Introducing Performance Central, a new site from SourceForge and
AppDynamics. Performance Central is your source for news, insights,
analysis and resources for efficient Application Performance Management.
Visit us today!
http://pubads.g.doubleclick.net/gampad/clk?id=48897511iu=/4140/ostg.clktrk
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] [FB-Tracker] Created: (DNET-515) Boolean support
Boolean support --- Key: DNET-515 URL: http://tracker.firebirdsql.org/browse/DNET-515 Project: .NET Data provider Issue Type: Task Components: ADO.NET Provider Affects Versions: 3.1.0.0 Environment: Win7 x64 - VS 2012 - .NET Provider 3.1.0.0 - Firebird 3.0.0 alpha 1 Reporter: Rand Random Assignee: Jiri Cincura Hi. Was trying to test the new boolean support, but couldnt create a new .EDMX file, everything seems to work with Firebird 3.0.0 but not the new boolean type. Getting the following exception: Unable to generate the model because of the following exception: 'The value for column 'DataType' in table 'TableDetails' is DBNull. Unable to cast object of type 'System.DBNull' to type 'System.String'. '. Loading metadata from the database took 00:00:00.4088832. Generating the model took 00:00:00.2426821. Unable to generate the model because of the following exception: 'The value for column 'DataType' in table 'TableDetails' is DBNull. Unable to cast object of type 'System.DBNull' to type 'System.String'. '. Loading metadata from the database took 00:00:00.3077974. Generating the model took 00:00:00.1603336. Added the connection string to the App.Config file. Writing the .edmx file took 00:00:00.0013773. Not sure if its a bug or just forgotten or not planned, though I kinda hoped since .NET Provider got update only few days before the Alpha 1 release that it has full support. -- 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 -- Get 100% visibility into Java/.NET code with AppDynamics Lite! It's a free troubleshooting tool designed for production. Get down to code-level detail for bottlenecks, with 2% overhead. Download for free and get started troubleshooting in minutes. http://pubads.g.doubleclick.net/gampad/clk?id=48897031iu=/4140/ostg.clktrk ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
