Test1
I Have only one connection to database.... and do that with this
connection...
1 - Create Table T1
2 - Insert 100 Records into T1
3 - Drop Table T1
Time so far : 5 Seconds
4 - Create Table T2
5 - Insert 100 Records into T2
6 - Drop Table T2
Time so Far: 30 Seconds (25 seconds Total steps 4,5,6)
--------------------//--------------------
Test2
I Have two connections to database.... the 2nd one to do the Drops
1 - Create Table T1
2 - Insert 100 Records into T1
3 - Drop Table T1 (Using 2nd Connection)
Time so far : 5 Seconds
4 - Create Table T2
5 - Insert 100 Records into T2
6 - Drop Table T2 (Using 2nd Connection)
Time so Far: 10 Seconds (5 seconds Total steps 4,5,6)
What is Happening ?
Why if I use the 2nd connection to do the drops the next inserts don't
complain ?
Tanks,
Jo�o Rodrigues
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
