hello dean,
yes,i am running super server on a multi-core/multi-CPU
machine.my code is as given below:-
Private Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Timer1.Tick
Dim ds As New DataSet
ds = SqlHelper.ExecuteDataset(fbsqlcon, CommandType.Text, "select
first 1 fullstr from TBL_50002 order by datadate")
If ds.Tables(0).Rows.Count > 0 Then
insertdata(ds.Tables(0).Rows(0).Item("fullstr"))
End If
Dim fullstr = ds.Tables(0).Rows(0).Item("fullstr")
SqlHelper.ExecuteNonQuery(fbsqlcon, CommandType.Text , "DELETE FROM
TBL_50002 WHERE fullstr = '" & ds.Tables(0).Rows(0).Item("fullstr").ToString()
& "'")
End Sub
Private Sub insertdata(ByVal str As String)
'Some calculation and insert values into table as-
Dim param(17) As FbParameter
param(0) = New FbParameter("@DATATYPE", datatype)
param(1) = New FbParameter("@DATADATE", datadate)
param(2) = New FbParameter("@RELFACT", relfact)
param(3) = New FbParameter("@SATELITE", satelite)
param(4) = New FbParameter("@LATITUDE", latitude)
param(5) = New FbParameter("@LONGITUDE", longitude)
param(6) = New FbParameter("@ANGLE", angle)
param(7) = New FbParameter("@SPEED", speed)
param(8) = New FbParameter("@DISTANCE", distance)
param(9) = New FbParameter("@DIRECTION", direction)
param(10) = New FbParameter("@LOC", loc)
param(11) = New FbParameter("@PIXELX", pixelx)
param(12) = New FbParameter("@PIXELY", pixely)
param(13) = New FbParameter("@FULLSTR", fullstr)
param(14) = New FbParameter("@SYSDATE", sysdate)
param(15) = New FbParameter("@ACIGNITION", acignitionStatus)
Dim strd As String = "INSERT INTO " + bbid + "
(datatype,datadate, relfact,satelite, latitude, longitude,
angle,
speed,distance,direction,loc,pixelx,pixely,fullstr,sysdate,acignition)
VALUES
(@DATATYPE,@DATADATE,@RELFACT,@SATELITE,@LATITUDE,@LONGITUDE,@ANGLE,@SPEED,@DISTANCE,@DIRECTION,@LOC,@PIXELX,@PIXELY,@FULLSTR,@SYSDATE,@ACIGNITION)"
SqlHelper.ExecuteNonQuery(fbsqlcon, CommandType.Text, "INSERT
INTO " + bbid + " (datatype,datadate, relfact,satelite, latitude,
longitude, angle, speed,
distance,direction,loc,pixelx,pixely,fullstr,sysdate,acignition) VALUES
(@DATATYPE,@DATADATE,@RELFACT,@SATELITE,@LATITUDE,@LONGITUDE,@ANGLE,@SPEED,@DISTANCE,@DIRECTION,@LOC,@PIXELX,@PIXELY,@FULLSTR,@SYSDATE,@ACIGNITION)",
param)
End Sub
On 10/23/07, [EMAIL PROTECTED] <
[EMAIL PROTECTED]> wrote:
>
> Send Firebird-net-provider mailing list submissions to
> [email protected]
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> or, via email, send a message with subject or body 'help' to
> [EMAIL PROTECTED]
>
> You can reach the person managing the list at
> [EMAIL PROTECTED]
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Firebird-net-provider digest..."
>
>
> Today's Topics:
>
> 1. Re: Firebird ADO.Net on x64 (Jiri Cincura)
> 2. patches for 64-bit data provider + embedded (2.1 beta 2)
> (Dean Harding)
> 3. firbird .net provider performance issue (harpal singh)
> 4. Re: firbird .net provider performance issue (Dean Harding)
> 5. Re: firbird .net provider performance issue (Jiri Cincura)
> 6. Re: patches for 64-bit data provider + embedded (2.1 beta 2)
> (Jiri Cincura)
> 7. Re: patches for 64-bit data provider + embedded (2.1 beta 2)
> (Carlos)
> 8. Re: patches for 64-bit data provider + embedded (2.1 beta 2)
> (Jiri Cincura)
> 9. Re: patches for 64-bit data provider + embedded (2.1 beta 2)
> (Jiri Cincura)
> 10. Re: patches for 64-bit data provider + embedded (2.1 beta 2)
> (Carlos)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Fri, 19 Oct 2007 15:00:44 +0200
> From: "Jiri Cincura" <[EMAIL PROTECTED]>
> Subject: Re: [Firebird-net-provider] Firebird ADO.Net on x64
> To: "For users and developers of the Firebird .NET providers"
> <[email protected]>
> Message-ID:
> <[EMAIL PROTECTED]>
> Content-Type: text/plain; charset=ISO-8859-1
>
> On 10/19/07, Viatcheslav Valerievitch Vassiliev <[EMAIL PROTECTED]>
> wrote:
> > After setting size of second parameter it throws null reference
> exception:
> >
> > cmd.Parameters.Add("@str_val", FbDbType.VarChar, 20);
> >
> > Provider seems to need some changes to be used with x64, my first test
> was
> > very initial. However it works for some operations - it can create
> database,
> > create table. So hopefully not too much changes are needed.
>
> It's similar problem. I think it's only about few changes in data
> handling between provider and embedded dll.
>
> --
> Jiri {x2} Cincura (Microsoft Student Partner)
> http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
>
>
>
> ------------------------------
>
> Message: 2
> Date: Mon, 22 Oct 2007 11:50:02 +1000
> From: Dean Harding <[EMAIL PROTECTED]>
> Subject: [Firebird-net-provider] patches for 64-bit data provider +
> embedded (2.1 beta 2)
> To: "For users and developers of the Firebird .NET providers"
> <[email protected]>
> Message-ID: <[EMAIL PROTECTED]>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Hi everyone,
>
> So I was playing around with the data provider and the 64-bit version of
> 2.1 beta 2 embedded this weekend, and I managed to get it to work.
>
> I've got a .zip containing my changes (as applied to the provider
> 2.5.0-alpha1) here:
> http://codeka.com/tmp/firebird.net-2.5.0-alpha1-64bit-patches.zip
>
> There wasn't a lot of changes required, really, though there is one that
> kind of worries me.
>
> The hardest thing for me to figure out was the fact that the XSQLVAR
> structures were being offset incorrectly in a 64-bit build. I don't know
> if it's due to a bug in the structure packing of the embedded DLL or
> what, but I had to change the XsqldaMarshaler.ComputeLength to read:
>
> private int ComputeLength(int n)
> {
> int length = (Marshal.SizeOf(typeof(XSQLDA)) +
> n * Marshal.SizeOf(typeof(XSQLVAR)));
>
> if (IntPtr.Size == 8)
> length += 4;
>
> return length;
> }
>
>
> Basically, we need to offset the first XSQLVAR structure by 4 in a
> 64-bit build.
>
> Other than that, the only other thing I had to change was the
> StatusVector stuff in IDbClient so that it's an IntPtr instead of an int.
>
> Now, I've only tested this against my little test app that I linked to
> last week, as well as doing a quick test on our own internal app (which
> does not make use of many of firebird's features *by far* so there's
> plenty of opportunity for other things to be screwed up still :-) but at
> least we're part of the way there...
>
> Dean.
>
>
>
>
> ------------------------------
>
> Message: 3
> Date: Mon, 22 Oct 2007 11:15:38 +0530
> From: "harpal singh" <[EMAIL PROTECTED]>
> Subject: [Firebird-net-provider] firbird .net provider performance
> issue
> To: [email protected]
> Message-ID:
> <[EMAIL PROTECTED]>
> Content-Type: text/plain; charset="iso-8859-1"
>
> hello all,
> we have migrate from ms-sql to firebird2.0(super server) for
> .net.but it is very slower than ms-sql.
> plz help me........
>
> harpal
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
> Message: 4
> Date: Mon, 22 Oct 2007 15:52:12 +1000
> From: Dean Harding <[EMAIL PROTECTED]>
> Subject: Re: [Firebird-net-provider] firbird .net provider performance
> issue
> To: "For users and developers of the Firebird .NET providers"
> <[email protected]>
> Message-ID: <[EMAIL PROTECTED]>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> harpal singh wrote:
> > hello all,
> > we have migrate from ms-sql to firebird2.0(super server)
> > for .net.but it is very slower than ms-sql.
> > plz help me........
>
> What, specifically, is slower? I'd like to see:
>
> 1. The statement used to create the relevant tables & indexes (both from
> SQL Server and Firebird)
> 2. The statement that is running slower in Firebird than on SQL Server.
>
> Also, are you running both databases on equivalent hardware? Are you
> running on a multi-core/multi-CPU machine? Super server can only use a
> single core, so if you've got multiple CPUs, you're better off with
> classic server (at least, until Firebird 3.0 is released).
>
> Dean.
>
>
>
>
> ------------------------------
>
> Message: 5
> Date: Mon, 22 Oct 2007 08:04:33 +0200
> From: "Jiri Cincura" <[EMAIL PROTECTED]>
> Subject: Re: [Firebird-net-provider] firbird .net provider performance
> issue
> To: "For users and developers of the Firebird .NET providers"
> <[email protected]>
> Message-ID:
> <[EMAIL PROTECTED]>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Are we talking about server or provider? Look like you're mixing this
> together.
>
> --
> Jiri {x2} Cincura (Microsoft Student Partner)
> http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
>
>
>
> ------------------------------
>
> Message: 6
> Date: Mon, 22 Oct 2007 08:07:04 +0200
> From: "Jiri Cincura" <[EMAIL PROTECTED]>
> Subject: Re: [Firebird-net-provider] patches for 64-bit data provider
> + embedded (2.1 beta 2)
> To: "For users and developers of the Firebird .NET providers"
> <[email protected]>
> Message-ID:
> <[EMAIL PROTECTED]>
> Content-Type: text/plain; charset=ISO-8859-1
>
> On 10/22/07, Dean Harding <[EMAIL PROTECTED]> wrote:
> > Other than that, the only other thing I had to change was the
> > StatusVector stuff in IDbClient so that it's an IntPtr instead of an
> int.
>
> This I've pathced in my local tree too. I'll try to run some test with
> your complete patch ('cause my isn't done :P) and let see, what will
> Carlos say. :)
>
> BTW good work.
>
> --
> Jiri {x2} Cincura (Microsoft Student Partner)
> http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
>
>
>
> ------------------------------
>
> Message: 7
> Date: Mon, 22 Oct 2007 08:54:35 +0200
> From: Carlos <[EMAIL PROTECTED]>
> Subject: Re: [Firebird-net-provider] patches for 64-bit data provider
> + embedded (2.1 beta 2)
> To: "For users and developers of the Firebird .NET providers"
> <[email protected]>
> Message-ID:
> <[EMAIL PROTECTED]>
> Content-Type: text/plain; charset=UTF-8
>
> Hello:
>
> > This I've pathced in my local tree too. I'll try to run some test with
> > your complete patch ('cause my isn't done :P) and let see, what will
> > Carlos say. :)
>
> If all nunit tests are running fine with the patch we can apply the
> patch in 2.5 sources.
>
> --
> Carlos Guzm?n ?lvarez
> Vigo-Spain
>
> Blog : http://carlosga.wordpress.com/
> FirebirdClient : http://www.firebirdsql.org/
> XMPP Client : http://code.google.com/p/xmppclient/
>
> ------------------------------
>
> Message: 8
> Date: Mon, 22 Oct 2007 20:43:47 +0200
> From: "Jiri Cincura" <[EMAIL PROTECTED]>
> Subject: Re: [Firebird-net-provider] patches for 64-bit data provider
> + embedded (2.1 beta 2)
> To: "For users and developers of the Firebird .NET providers"
> <[email protected]>
> Message-ID:
> <[EMAIL PROTECTED]>
> Content-Type: text/plain; charset=ISO-8859-1
>
> On 10/22/07, Carlos <[EMAIL PROTECTED]> wrote:
> > If all nunit tests are running fine with the patch we can apply the
> > patch in 2.5 sources.
>
> I'll run these tests during this night. So during 12h i'll be there with
> result.
>
> --
> Jiri {x2} Cincura (Microsoft Student Partner)
> http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
>
>
>
> ------------------------------
>
> Message: 9
> Date: Tue, 23 Oct 2007 10:11:17 +0200
> From: "Jiri Cincura" <[EMAIL PROTECTED]>
> Subject: Re: [Firebird-net-provider] patches for 64-bit data provider
> + embedded (2.1 beta 2)
> To: "For users and developers of the Firebird .NET providers"
> <[email protected]>
> Message-ID:
> <[EMAIL PROTECTED]>
> Content-Type: text/plain; charset=ISO-8859-1
>
> OK, I've run tests. No new problems. I've commited this patch to SVN.
> If there's somebody interested in this build, I can send it, just let
> me know.
>
> --
> Jiri {x2} Cincura (Microsoft Student Partner)
> http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
>
>
>
> ------------------------------
>
> Message: 10
> Date: Tue, 23 Oct 2007 10:13:40 +0200
> From: Carlos <[EMAIL PROTECTED]>
> Subject: Re: [Firebird-net-provider] patches for 64-bit data provider
> + embedded (2.1 beta 2)
> To: "For users and developers of the Firebird .NET providers"
> <[email protected]>
> Message-ID:
> <[EMAIL PROTECTED]>
> Content-Type: text/plain; charset=UTF-8
>
> Hello:
>
> > OK, I've run tests. No new problems. I've commited this patch to SVN.
> > If there's somebody interested in this build, I can send it, just let
> > me know.
>
> Nice :)
>
> --
> Carlos Guzm?n ?lvarez
> Vigo-Spain
>
> Blog : http://carlosga.wordpress.com/
> FirebirdClient : http://www.firebirdsql.org/
> XMPP Client : http://code.google.com/p/xmppclient/
>
> ------------------------------
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems? Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
>
> ------------------------------
>
> _______________________________________________
> Firebird-net-provider mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
> End of Firebird-net-provider Digest, Vol 18, Issue 11
> *****************************************************
>
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
