Hello Carlos, I would be happy to do that if I knew how! <grin> We're using the ADO.NET provider with a large business app that will be replacing an old win32 one. It's in beta now and I'm fine tuning performance with Firebird. It also supports MS SQL server through a data access layer so I can easily test the same data and queries against either one.
I finally found the CVS and looked at it but I can't figure out which is not using regex and I can't do a build here on my production machine because a) I have no idea how to build the project, b) not a lot of time at the moment (understatement of the year) and c) I couldnt' figure out if you meant there is one that uses regex and one that doesn't or if you meant the latest version in the cvs doesn't use regex at all. I'd be happy to test any binary here, I have what is probably an excellent test bed considering the sheer size of our application the huge real world test data we have from importing from our previous version of our application and the ability to compare it against MS SQL providers and database and easily time it in nprof to determine where the differences are. But without a binary I'm a bit handcuffed at the moment. If I had more time and we were out of beta I'd really like to get into the source of the provider and help improve it as we intend to go with Firebird as an alternative for many of our business applications and I think I could bring some good experience to it, but at the moment unfortunately I just don't have the time for it. I have since re-written the queries wherever critical to not call another query inside a loop so I'm not in a panic about it anymore, but as I said I'd be happy to test a binary if one were available. Whenever I look at the sourceforge stuff it's a complete mystery to me how it all works and is organized. I'm sure I'm not alone being a working commercial developer with a lot of experience but more used to using Visual Studio and it's project and solution system. If there is a getting started link for testing and building the provider for people with no idea about SourceForge I'd appreciate a link so down the road I can get more into it. If you can point me to a binary to test I'd be happy to do that and report back. - John -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Carlos Guzmán Álvarez Sent: Sunday, January 08, 2006 4:15 AM To: [email protected] Subject: Re: [Firebird-net-provider] 1.7A FbCommand::ParseNamedParameters performance issue (possibly a bug)? Hello: >I ran the app in Nprof and found that the performance hit is in >FbCommand::ParseNamedParameters (called by FbCommand::Prepare) which in >turn calls a bunch of regex functions. > Could you make the same test using the CVS sources, that are not using regex for named parameters parsing. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37&alloc_id865&op=click _______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
