コード例 #1
0
        public void IbatisOnly()
        {
            for (int n = 2; n < 4000; n *= 2)
            {
                Simple[] simples = new Simple[n];
                object[] ids = new object[n];
                for (int i = 0; i < n; i++)
                {
                    simples[i] = new Simple();
                    simples[i].Init();
                    simples[i].Count = i;
                    simples[i].Id = i;
                }

                //Now do timings
                Stopwatch stopWatch = new Stopwatch();
                GC.Collect();
                GC.WaitForPendingFinalizers();

                ISession session = sessionFactory.OpenSession();
                stopWatch.Start();
                Ibatis(session, simples, n, "h1");
                stopWatch.Stop();
                double ibatis = 1000000 * (stopWatch.ElapsedMilliseconds  / (double)n);
                session.Close();

                session = sessionFactory.OpenSession();
                stopWatch.Start();
                Ibatis(session, simples, n, "h2");
                stopWatch.Stop();
                ibatis += 1000000 * (stopWatch.ElapsedMilliseconds / (double)n);
                session.Close();

                session = sessionFactory.OpenSession();
                stopWatch.Start();
                Ibatis(session, simples, n, "h2");
                stopWatch.Stop();
                ibatis += 1000000 * (stopWatch.ElapsedMilliseconds / (double)n);
                session.Close();

                System.Console.WriteLine("Objects: " + n + " - iBATIS DataMapper: " + ibatis.ToString("F3"));
            }
            System.GC.Collect();
        }
コード例 #2
0
        private void Ibatis(ISession session, Simple[] simples, int N, string runname)
        {
            using (ITransaction transaction = session.BeginTransaction())
            {
                for (int i = 0; i < N; i++)
                {
                    dataMapper.Insert("InsertSimple", simples[i]);
                }

                for (int i = 0; i < N; i++)
                {
                    simples[i].Name = "NH - " + i + N + runname + " - " + System.DateTime.Now.Ticks;
                    dataMapper.Update("UpdateSimple", simples[i]);
                }

                for (int i = 0; i < N; i++)
                {
                    dataMapper.Delete("DeleteSimple", simples[i].Id);
                }
                transaction.Complete();
            }
        } 
コード例 #3
0
        public void Simultaneous()
        {
            double ibatis = 0;
            double adonet = 0;

            IDbConnection connection = sessionFactory.DataSource.DbProvider.CreateConnection();
            connection.ConnectionString = sessionFactory.DataSource.ConnectionString;

            for (int n = 2; n < 4000; n *= 2)
            {
                Simple[] simples = new Simple[n];
                for (int i = 0; i < n; i++)
                {
                    simples[i] = new Simple();
                    simples[i].Init();
                    simples[i].Count = i;
                    simples[i].Id = i;
                }

                ISession session = sessionFactory.OpenSession();
                Ibatis(session, simples, n, "h0");
                session.Close();

                connection.Open();
                DirectAdoNet(connection, simples, n, "j0");
                connection.Close();

                session = sessionFactory.OpenSession();
                Ibatis(session, simples, n, "h0");
                session.Close();

                connection.Open();
                DirectAdoNet(connection, simples, n, "j0");
                connection.Close();

                //Now do timings
                Stopwatch stopWatch = new Stopwatch();

                GC.Collect();
                GC.WaitForPendingFinalizers();

                session = sessionFactory.OpenSession();
                stopWatch.Start();
                Ibatis(session, simples, n, "h1");
                stopWatch.Stop();
                ibatis = 1000000 * (stopWatch.ElapsedMilliseconds / (double)n);
                session.Close();

                connection.Open();
                stopWatch.Start();
                DirectAdoNet(connection, simples, n, "j1");
                stopWatch.Stop();
                adonet = 1000000 * (stopWatch.ElapsedMilliseconds / (double)n);
                connection.Close();

                session = sessionFactory.OpenSession();
                stopWatch.Start();
                Ibatis(session, simples, n, "h2");
                stopWatch.Stop();
                ibatis += 1000000 * (stopWatch.ElapsedMilliseconds / (double)n);
                session.Close();

                connection.Open();
                stopWatch.Start();
                DirectAdoNet(connection, simples, n, "j2");
                stopWatch.Stop();
                adonet += 1000000 * (stopWatch.ElapsedMilliseconds / (double)n);
                connection.Close();

                session = sessionFactory.OpenSession();
                stopWatch.Start();
                Ibatis(session, simples, n, "h2");
                stopWatch.Stop();
                ibatis += 1000000 * (stopWatch.ElapsedMilliseconds / (double)n);
                session.Close();

                connection.Open();
                stopWatch.Start();
                DirectAdoNet(connection, simples, n, "j2");
                stopWatch.Stop();
                adonet += 1000000 * (stopWatch.ElapsedMilliseconds / (double)n);
                connection.Close();
                System.Console.Out.WriteLine("Objects " + n + " iBATIS DataMapper : " + ibatis.ToString("F3") + " / Direct ADO.NET: " + adonet.ToString("F3") + " Ratio: " + ((ibatis / adonet)).ToString("F3"));
            }

            System.GC.Collect();
        }
コード例 #4
0
        public void Many()
        {
            double ibatis = 0;
            double adonet = 0;

            for (int n = 0; n < 5; n++)
            {
                Simple[] simples = new Simple[n];
                for (int i = 0; i < n; i++)
                {
                    simples[i] = new Simple();
                    simples[i].Init();
                    simples[i].Count = i;
                    simples[i].Id = i;
                }

                ISession session = sessionFactory.OpenSession();
                Ibatis(session, simples, n, "h0");
                session.Close();

                IDbConnection connection = sessionFactory.DataSource.DbProvider.CreateConnection();
                connection.ConnectionString = sessionFactory.DataSource.ConnectionString;

                connection.Open();
                DirectAdoNet(connection, simples, n, "j0");
                connection.Close();

                session = sessionFactory.OpenSession();
                Ibatis(session, simples, n, "h0");
                session.Close();

                connection.Open();
                DirectAdoNet(connection, simples, n, "j0");
                connection.Close();

                // now do timings

                int loops = 30;
                Stopwatch stopWatch = new Stopwatch();

                for (int runIndex = 1; runIndex < 4; runIndex++)
                {
                    GC.Collect();
                    GC.WaitForPendingFinalizers();

                    stopWatch.Start();
                    for (int i = 0; i < loops; i++)
                    {
                        session = sessionFactory.OpenSession();
                        Ibatis(session, simples, n, "h" + runIndex.ToString());
                        session.Close();
                    }
                    stopWatch.Stop();
                    ibatis += 1000000 * (stopWatch.ElapsedMilliseconds / (double)loops);

                    GC.Collect();
                    GC.WaitForPendingFinalizers();

                    stopWatch.Start();
                    for (int i = 0; i < loops; i++)
                    {
                        connection.Open();
                        DirectAdoNet(connection, simples, n, "j" + runIndex.ToString());
                        connection.Close();
                    }
                    stopWatch.Stop();
                    adonet += 1000000 * (stopWatch.ElapsedMilliseconds / (double)loops);


                }
            }
            System.Console.Out.WriteLine("iBatis DataMapper : " + ibatis.ToString("F3") + " / Direct ADO.NET: " + adonet.ToString("F3") + " Ratio: " + ((ibatis / adonet)).ToString("F3"));

            System.GC.Collect();
        }
コード例 #5
0
        private void DirectAdoNet(IDbConnection c, Simple[] simples, int N, string runname)
        {
            IDbCommand insert = InsertCommand();
            IDbCommand delete = DeleteCommand();
            IDbCommand select = SelectCommand();
            IDbCommand update = UpdateCommand();

            IDbTransaction t = c.BeginTransaction();

            insert.Connection = c;
            delete.Connection = c;
            select.Connection = c;
            update.Connection = c;

            insert.Transaction = t;
            delete.Transaction = t;
            select.Transaction = t;
            update.Transaction = t;

            insert.Prepare();
            delete.Prepare();
            select.Prepare();
            update.Prepare();

            for (int i = 0; i < N; i++)
            {
                ((IDbDataParameter)insert.Parameters[0]).Value = simples[i].Name;
                ((IDbDataParameter)insert.Parameters[1]).Value = simples[i].Address;
                ((IDbDataParameter)insert.Parameters[2]).Value = simples[i].Count;
                ((IDbDataParameter)insert.Parameters[3]).Value = simples[i].Date;
                ((IDbDataParameter)insert.Parameters[4]).Value = simples[i].Pay;
                ((IDbDataParameter)insert.Parameters[5]).Value = simples[i].Id;

                insert.ExecuteNonQuery();
            }

            for (int i = 0; i < N; i++)
            {
                ((IDbDataParameter)update.Parameters[0]).Value = "DR - " + i + N + runname + " - " + System.DateTime.Now.Ticks;
                ((IDbDataParameter)update.Parameters[1]).Value = simples[i].Address;
                ((IDbDataParameter)update.Parameters[2]).Value = simples[i].Count;
                ((IDbDataParameter)update.Parameters[3]).Value = simples[i].Date;
                ((IDbDataParameter)update.Parameters[4]).Value = simples[i].Pay;
                ((IDbDataParameter)update.Parameters[5]).Value = simples[i].Id;

                update.ExecuteNonQuery();
            }

            for (int i = 0; i < N; i++)
            {
                ((IDbDataParameter)delete.Parameters[0]).Value = simples[i].Id;
                delete.ExecuteNonQuery();
            }

            t.Commit();
        }
コード例 #6
0
        public void AdoNetOnly()
        {
            for (int n = 2; n < 4000; n *= 2)
            {
                Simple[] simples = new Simple[n];
                for (int i = 0; i < n; i++)
                {
                    simples[i] = new Simple();
                    simples[i].Init();
                    simples[i].Count = i;
                    simples[i].Id = i;
                }

                //Now do timings
                Stopwatch stopWatch = new Stopwatch();

                IDbConnection _connection = sessionFactory.DataSource.DbProvider.CreateConnection();
                _connection.ConnectionString = sessionFactory.DataSource.ConnectionString;

                _connection.Open();

                stopWatch.Start();
                DirectAdoNet(_connection, simples, n, "j1");
                stopWatch.Stop();
                double adonet = 1000000 * (stopWatch.ElapsedMilliseconds / (double)n);
                _connection.Close();

                _connection.Open();
                stopWatch.Start();
                DirectAdoNet(_connection, simples, n, "j2");
                stopWatch.Stop();
                adonet += 1000000 * (stopWatch.ElapsedMilliseconds / (double)n);
                _connection.Close();

                _connection.Open();
                stopWatch.Start();
                DirectAdoNet(_connection, simples, n, "j2");
                stopWatch.Stop();
                adonet += 1000000 * (stopWatch.ElapsedMilliseconds / (double)n);
                _connection.Close();

                System.Console.Out.WriteLine("Objects: " + n + " Direct ADO.NET: " + adonet.ToString("F3"));
            }
            System.GC.Collect();
        }