Posts: 315
Threads: 6
Joined: Dec 2010
Reputation:
0
I suggest that you save them in a text file.
Posts: 534
Threads: 27
Joined: Jan 2012
Reputation:
0
Firstly reduce the size of query 500 is too much 128 will also much for your query
This will effect the processer usage amd may be also query speed
Posts: 374
Threads: 11
Joined: Feb 2011
Reputation:
0
Well what do you think? you're sending 3000 quaries ofcourse it's gonna take 10 minutes, be lucky your server doesn't crash because of that.
Posts: 358
Threads: 38
Joined: May 2010
Reputation:
0
nah it will not crash when i send like 10000 queries too but does someone know the SQL Lite will be better for this ? or is same like a mysql?
Posts: 10,066
Threads: 38
Joined: Sep 2007
Reputation:
0
Worse. Thread the queries and you should see a huge performance increase.