Hello All.
I am using .net Compact Framework 2 sp 2 with FirebirdClient-2.0.1-Compact
to access FireBird 2.01 SS.
Have very slow data transfers to device!
Example code:
======================================================================
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using FirebirdSql.Data.FirebirdClient;
using System.Data.SqlClient;
namespace DeviceApplication1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
// NETCF 2 SP2
// FirebirdClient-2.1.0-RC1-NETCF
(FirebirdClient-2.0.1-Compact-Bin)
// FB 2.01 SS
FbConnection fbconn = new FbConnection(@"initial catalog=MB;data
source=192.168.4.230;user id=SYSDBA;password=masterkey;character
set=NONE;Packet Size=32767;Fetch Size=100");
fbconn.Open();
listBox1.Items.Clear();
listBox1.Items.Add("FireBird");
listBox1.Items.Add(DateTime.Now.ToString("hh:mm:ss:ffff"));
using (FbCommand cmd = fbconn.CreateCommand())
{
int i = 0;
cmd.CommandText = "select * from Arts";
using (FbDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
i++;
}
listBox1.Items.Add(i.ToString()); // >14000 RECORDS
listBox1.Items.Add(DateTime.Now.ToString("hh:mm:ss:ffff"));
// from SmartDevice2003 == 2 MIN !!!
// from PC < 2sec
}
fbconn.Close();
// NETCF 2 SP2
// MS SQL 2000 Sp3
// MS Client 2.0
SqlConnection conn = new
SqlConnection("Server=192.168.4.14,51798;Uid=sa;Pwd=sa;DataBase=mb;");
conn.Open();
listBox1.Items.Add("MS SQL");
listBox1.Items.Add(DateTime.Now.ToString("hh:mm:ss:ffff"));
using (SqlCommand cmd = conn.CreateCommand())
{
int i = 0;
cmd.CommandText = "select * from Arts";
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
i++;
}
listBox1.Items.Add(i.ToString()); // >14000 RECORDS
listBox1.Items.Add(DateTime.Now.ToString("hh:mm:ss:ffff"));
// from SmartDevice2003 == 4 SEC !!!
// from PC < 1 sec
}
conn.Close();
}
}
}
/* CREATE TABLE ARTS (
ID INTEGER NOT NULL,
NAME VARCHAR(100),
ARTGROUPID INTEGER,
ENABLED SMALLINT,
DATEUPD TIMESTAMP,
NUMINPACK INTEGER,
STATE CHAR(1),
ARTNUMINPACKCOEFF DOUBLE PRECISION
);
*/
======================================================================
With desktop application NET 2 more faster:
Have any idea?
Thanks
Sergey
-------------------------------------------------------------------------
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
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
