summaryrefslogtreecommitdiff
path: root/test/perf/poolload.py
diff options
context:
space:
mode:
authorMike Bayer <mike_mp@zzzcomputing.com>2011-01-16 20:24:05 -0500
committerMike Bayer <mike_mp@zzzcomputing.com>2011-01-16 20:24:05 -0500
commitcbaa4c9d5d51308aeb5331b177e16d65c6dda163 (patch)
tree7ee800792c851431657a9630ae693c341e5418d6 /test/perf/poolload.py
parenta9a67667901e24eefb36e01334eed9bf25b2b144 (diff)
downloadsqlalchemy-cbaa4c9d5d51308aeb5331b177e16d65c6dda163.tar.gz
- remove old perf/ tests from pre-2007
Diffstat (limited to 'test/perf/poolload.py')
-rw-r--r--test/perf/poolload.py37
1 files changed, 0 insertions, 37 deletions
diff --git a/test/perf/poolload.py b/test/perf/poolload.py
deleted file mode 100644
index 345720f0c..000000000
--- a/test/perf/poolload.py
+++ /dev/null
@@ -1,37 +0,0 @@
-# load test of connection pool
-import thread, time
-from sqlalchemy import *
-import sqlalchemy.pool as pool
-from test.lib import testing
-
-db = create_engine(testing.db.url, pool_timeout=30, echo_pool=True)
-metadata = MetaData(db)
-
-users_table = Table('users', metadata,
- Column('user_id', Integer, primary_key=True),
- Column('user_name', String(40)),
- Column('password', String(10)))
-metadata.drop_all()
-metadata.create_all()
-
-users_table.insert().execute([{'user_name':'user#%d' % i, 'password':'pw#%d' % i} for i in range(1000)])
-
-def runfast():
- while True:
- c = db.pool.connect()
- time.sleep(.5)
- c.close()
-# result = users_table.select(limit=100).execute()
-# d = {}
-# for row in result:
-# for col in row.keys():
-# d[col] = row[col]
-# time.sleep(.005)
-# result.close()
- print "runfast cycle complete"
-
-#thread.start_new_thread(runslow, ())
-for x in xrange(0,50):
- thread.start_new_thread(runfast, ())
-
-time.sleep(100)