internal FastDbCommand(FastDbConnection connection)
{
this.connection = connection;
statement = -1;
sql = "";
described = false;
sql_changed = false;
bof = false;
eof = false;
rec_no = -1;
table_name = "";
read_only = true;
row_count = 0;
fields = new FastDbFields();
vars = new FastDbParameters();
}
internal FastDbCommand(FastDbConnection connection)
{
this.connection = connection;
statement = -1;
sql = "";
described = false;
sql_changed = false;
bof = false;
eof = false;
rec_no = -1;
table_name = "";
read_only = true;
row_count = 0;
fields = new FastDbFields();
vars = new FastDbParameters();
}
internal FastDbCommand(FastDbConnection connection, string sql)
: this(connection)
{
this.sql = sql;
}
internal FastDbCommand(FastDbConnection connection, string sql) : this(connection) {
this.sql = sql;
}
static void Main(string[] args)
{
int rc;
uint oid = 0;
int nRecords = 3;
FastDbConnection connection = new FastDbConnection("test");
connection.InitDbSize = FastDbConnection.DefaultInitDatabaseSize*2;
connection.InitIdxSize = FastDbConnection.DefaultInitIndexSize*2;
connection.ExtensionQuantum = FastDbConnection.DefaultExtensionQuantum*2;
connection.Open();
FastDbFields fields = new FastDbFields();
fields.Add("int_field", CLI.FieldType.cli_int8, CLI.FieldFlags.cli_hashed);
fields.Add("str_field", CLI.FieldType.cli_asciiz, CLI.FieldFlags.cli_indexed);
rc = connection.CreateTable("test", fields);
if (rc < 0) Console.WriteLine("cli_create_table: {0}", CLI.CliErrorToStr(rc));
FastDbCommand command = connection.CreateCommand("insert into test");
command.Fields.Assign(fields); // You could also do: command.Describe();
DateTime time = DateTime.Now;
long key = 1999;
for (int i = 0; i < nRecords; i++)
{
key = (3141592621L * key + 2718281829L) % 1000000007L;
command.Fields[0].asInt64 = key;
command.Fields[1].asString = key.ToString();
oid = command.Insert();
}
connection.Commit();
Console.WriteLine(String.Format("Elapsed time for inserting {0} records: {1} (speed: {2:F2})", nRecords, DateTime.Now - time, nRecords*1000 / (DateTime.Now - time).TotalMilliseconds));
command = connection.CreateCommand("insert into persons");
command.Fields.Add("name", CLI.FieldType.cli_asciiz, CLI.FieldFlags.cli_indexed);
command.Fields.Add("salary", CLI.FieldType.cli_int8);
command.Fields.Add("address", CLI.FieldType.cli_asciiz);
command.Fields.Add("weight", CLI.FieldType.cli_real8);
command.Fields.Add("subordinates", CLI.FieldType.cli_array_of_oid, CLI.FieldFlags.cli_noindex, "persons");
rc = connection.CreateTable("persons", command.Fields);
if (rc < 0)
Console.WriteLine("cli_create_table: {0}", rc);
Console.WriteLine("Name\tType\tSize\tCapacity\tFlags");
for (int i=0; i < command.Fields.Count; ++i)
{
FastDbField f = command.Fields[i];
Console.WriteLine("{0}\t{1}\t{2}\t{3}\t{4}",
f.Name, f.Type, f.Size, f.Capacity, f.Flags);
}
connection.Commit();
time = DateTime.Now;
for (int i=0; i < nRecords; ++i)
{
int n = 0;
command.Fields[n++].asString = String.Format("Name{0}", i+1);
command.Fields[n++].asInt64 = (i+1) * 1000;
command.Fields[n++].asString = String.Format("Address {0}", 100-i);
command.Fields[n++].asDouble = (i+1) * 100;
command.Fields[n].ArraySize = (i==0) ? 0 : 1;
if (i > 0)
command.Fields[n].SetArrayValue(0, oid);
oid = command.Insert();
}
connection.Commit();
Console.WriteLine("Elapsed time for inserting {0} records: {1} (speed: {2:F2})", nRecords, DateTime.Now - time, nRecords*1000 / (DateTime.Now - time).TotalMilliseconds);
command = connection.CreateCommand("select * from persons");
//command.Execute();
DumpRecords(command);
connection.Commit();
command = connection.CreateCommand(@"select * from persons where length(subordinates) < %subordinates and salary > %salary");
command.Parameters.Add("subordinates", CLI.FieldType.cli_int4);
command.Parameters.Add("salary", CLI.FieldType.cli_int8);
command.Parameters["subordinates"].asInteger = 1;
command.Parameters["salary"].asInteger = 100;
//command.Execute();
DumpRecords(command);
}
static void Main(string[] args)
{
int rc, i, n;
uint oid = 0;
int nRecords = 200000;
FastDbConnection connection = new FastDbConnection("test");
connection.InitDbSize = FastDbConnection.DefaultInitDatabaseSize*2;
connection.InitIdxSize = FastDbConnection.DefaultInitIndexSize*2;
connection.ExtensionQuantum = FastDbConnection.DefaultExtensionQuantum*2;
connection.Open();
FastDbFields fields = new FastDbFields();
fields.Add("int_field", CLI.FieldType.cli_int8, CLI.FieldFlags.cli_hashed);
fields.Add("str_field", CLI.FieldType.cli_asciiz, CLI.FieldFlags.cli_hashed);
rc = connection.CreateTable("test", fields);
if (rc < 0) Console.WriteLine("cli_create_table: {0}", CLI.CliErrorToStr(rc));
FastDbCommand command = connection.CreateCommand("insert into test");
command.Fields.Assign(fields); // You could also do: command.Describe();
DateTime start = DateTime.Now;
long key = 1999;
for (i = 0; i < nRecords; i++) {
key = (3141592621L * key + 2718281829L) % 1000000007L;
command.Fields[0].asInt64 = key;
command.Fields[1].asString = key.ToString();
oid = command.Insert();
}
connection.Commit();
Console.WriteLine("Elapsed time for inserting {0} records: {1:F2} (speed: {2:F2})",
nRecords,
(DateTime.Now - start).TotalSeconds,
nRecords / (DateTime.Now - start).TotalSeconds);
FastDbCommand command1 = connection.CreateCommand("select * from test where int_field = %key");
FastDbCommand command2 = connection.CreateCommand("select * from test where str_field = %key");
command1.Parameters.Add("key", CLI.FieldType.cli_int8);
command2.Parameters.Add("key", CLI.FieldType.cli_asciiz);
command1.Fields.Assign(fields);
command2.Fields.Assign(fields);
int rc1;
int rc2;
key = 1999;
start = System.DateTime.Now;
for (i = 0; i < nRecords; i++) {
key = (3141592621L * key + 2718281829L) % 1000000007L;
command1.Parameters[0].asInt64 = key;
command2.Parameters[0].asString = key.ToString();
rc1 = command1.Execute();
rc2 = command2.Execute();
}
System.Console.WriteLine("Elapsed time for performing {0} index searches {1:F2} (speed: {2:F2})",
nRecords * 2, (DateTime.Now - start).TotalSeconds,
nRecords * 2 / (DateTime.Now - start).TotalSeconds);
command.SQL = "select * from test";
start = System.DateTime.Now;
n = command.Execute();
for(i=0; i < n; i++) {
command.Next();
}
Console.WriteLine(String.Format("Elapsed time for iteration through {0} records: {1:F2} (speed: {2:F2})",
nRecords,
(DateTime.Now - start).TotalSeconds,
nRecords / (DateTime.Now - start).TotalSeconds));
start = System.DateTime.Now;
/*
key = 1999;
for (i = 0; i < nRecords; i++) {
key = (3141592621L * key + 2718281829L) % 1000000007L;
Record rec = (Record) intIndex.Get(new Key(key));
Record removed = (Record)intIndex.Remove(new Key(key));
Debug.Assert(removed == rec);
strIndex.Remove(new Key(System.Convert.ToString(key)), rec);
rec.Deallocate();
}*/
command.Execute(true);
command.Delete();
connection.Commit();
System.Console.WriteLine("Elapsed time for deleting {0} records: {1:F2} (speed: {2:F2})",
nRecords,
(DateTime.Now - start).TotalSeconds,
nRecords/(DateTime.Now - start).TotalSeconds);
}
