When ever I run a query that exceeds 30 queries the time for the query to run goes from less than a second to over 10 seconds to get data. Example I run a query to return 29 rows, it takes .1 seconds, I run a query to return 31 rows it takes 11.2 seconds. I am running mySQL on Windows 2008 Server Dual Core 2.6Ghz with 3GB of Memory. The machine doesn't run anything else.
I downloaded (net install) Centos 6 a couple of days ago. It loaded fine. But it is stuck in very tiny fonts on the screen as it display 64 Rows by 160 Columns. I would like to get to 25 Rows of... [by jwhitney]
I put my pre-loaded sqlite database on my application, everythings works fine, the connection is Ok, the existence of the database is ok. But, when i query with select some rows return empty data in just one column.
I'm looking for a simple way to check the rows in the database if the imagePath is equal to the column TABLE_IMAGE_PATH. First I was thinking of doing a loop and began with a request to check how many rows there are in the table, but then I got lost! And I guess there is better ways to do this with perhaps Do While?!