optimization

Is it possible to create a drag from mysql and count the total number of rows, but only get 20 rows at a time?

This is my first question here so please don't be tough on me... :P I usually tend to google my way to a solution but now I'm in a hurry and have…

So I have ~10 million records in an excel file that have to be parsed out in a specific way (I can't just convert to CSV and insert it like that)…

how can I optimize the server with following configuration. It takes too much time to load a page. IBM X3200 M3 Server - 1 Intel Xeon Processor with…

Below is my Table Structure Table 1 id name Table 2 id table1_id I want the rows from table 1 which have no reference value in table 2. Example…

I've been monitoring my Apache Status lately, and a lot of my users are saying how slow the site is to respond. Here is the Apache Status: Current…

I', working hard to get the caching on my site PERFECT, but with so many options I'm a big lost. I've been testing with google 'Page Speed' to see…

I have this query. I want to optimization this query,because it takes more then 4.sec ![SELECT clerk_id, COUNT(*) AS num FROM `contracts` WHERE…

I have a table which has 4-5 varchar columns and an int column(last column of the row). This int column is constantly updated using an UPDATE query.…

i have a very simple query that im trying to optimize, its taking 2~5 secs to execute. This is my CREATE TABLE CREATE TABLE `artist` ( `id` INTEGER…

I am having some trouble optimizing a query, and was hoping that someone here might be able to provide a few pointers. I have two tables: CREATE…

How much can the following query be changed to improve it's performance on a "large" database? SELECT SQL_CALC_FOUND_ROWS wp_rb_posts.* FROM…

I am the lead engineer for a startup, and because of that, I am in charge of managing the servers. When building/purchasing servers for the site, It…

I'm wondering what's the best column type to store latitude/longitude on MySQL + Rails. Precision must be enough to store every bit of lat/lng…

Using InnoDB in MySQL, I want to speed up selects by utilizing the clustered index better, thus including more frequently used columns in the…

I have an on-the-fly thumbnailing system and am trying to find the best way to make sure it's as fast as possible when serving up images. Here is…

I am a php/mysql developer learning android. I am creating an android app that receives info from my php app to create list views of different…

select active from websites where id = (select max(id) from websites where url = 'google.com') id select_type table type possible_keys key key_len…

I have two tables. The first one contains all the item informations and the second contains the item ID with a category ID. The reason of that is…

This is simplified version of a relatively complex problem that myself and my colleagues can't quite get our heads around. Consider two tables,…