The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
2answers
256 views

MySQL database really slow with a really big table [closed]

I have a MySQL table with 150 million rows. Below is its data structure. Below is some of its data. Now, using PHP My Admin I ran the below command. SELECT `iwords` FROM `wordstable` WHERE ...
3
votes
2answers
358 views

select() hangs due to resource exhaustion - but what resource?

Connecting to my server via sftp sometimes results in a hang here: if (select(max+1, rset, wset, NULL, NULL) < 0) { which is line 1428 from openssh 5.2p1's sftp-server.c (main loop of ...
1
vote
1answer
506 views

GRANT PERMISSIONS ON SQL Server 2008,

I got the following issues while querying a database, and somehow I am not yet able to resolve it. 1. The SELECT permission was denied on the object So I executed the following command on SSMS ( I ...
2
votes
6answers
239 views

SQL Server 2005: Selects good, Inserts bad

We've come across a perplexing problem with our database application. We're running the application in 3 different (but similarly spec'd) environments. Select Insert Env1 0.81ms 0.94ms ...