CODEWITHSUNDEEP
mysqlsql
mgokhanbakal
mgokhanbakal

Reputation: 1727

Using RAND() keyword in more than one query at the same time

I am querying a table by 

SELECT tweetId, userName, tweetContent, tweetDate
FROM
 db.tweetentities
 WHERE applicationId = 3 
ORDER BY RAND() 
LIMIT 0, 88 INTO OUTFILE '/tmp/theme_3.txt';

So, is it wrong to execute a same query in the same table at the same time?

I dont have much time that's why I want to generate files as soon as possible?

Could you please tell me whether it will cause performance issues or not?

Thanks.

Upvotes: 0

Views: 35

Answers (1)

131
131

Reputation: 3361

SGBD are supposed to handle multiple queries at the same time. You can worry about the "file writing" part, but the rand() keyword dont come with any drawback in this situation

Upvotes: 1

Related Questions