* Not logged in  
Login :: Register :: Home 
RSS Feeds :: Classifieds
Contact Us :: About :: Help 
All Categories
Computers and Internet 
Software 
Linux Servers 
(No SubCategories)
(Feeds)
Subscribe Apache News 
Subscribe Apache News Online 
Subscribe eWEEK Linux 
Subscribe Linux Home Server Memo 
Subscribe Linux Server Security Secrets 
Subscribe Linux Voodoo 
Subscribe Linux.com: Servers 
Subscribe MySQL User Forums 
Subscribe NewsForge 
Subscribe PRWeb: Computer Linux 
Subscribe Server : Linux 
Subscribe Slashdot: Linux 
Subscribe SUSE Linux Enterprise Server 
Subscribe The Linux Security 
SHARE
Slow COUNT query (3 replies)
(MySQL.com) Hi, I have a table which deals with quote requests - there are about 50000 records. When trying to count the number of quotes given out each month, the query is painfully slow - I am using the following query: SELECT DATE_FORMAT('quote_time','
Update update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 1268 failed: 1142 [UPDATE command denied to user '334187_hdlns_ms5'@'10.187.248.89' for table 'feed'] in [update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 1268]
updated 1268 (MySQL User Forums), inserted 30, updated 0, at 2012-06-01 15:36:44
Articles from: MySQL User Forums (MySQL.com)  Subscribe
... More from Category: Computers and Internet / Software / Linux Servers
Previous Page - Next Page  
Error "no database selected" (1 reply) (more)2010 03 11
VARCHAR as primary key - bad? (1 reply) (more)2010 03 11
puzzle in next-key (1 reply) (more)2010 03 11
Setting up new databases and accounts (1 reply) (more)2010 03 11
Standardising data from different sources (1 reply) (more)2010 03 11
Bug query spatial data (no replies) (more)2010 03 11
condensing queries (1 reply) (more)2010 03 11
Inserting HTML data into MySQL - Basic logic questions :) (3 replies) (more)2010 03 11
Inserting HTML data into MySQL - Basic logic questions :) (-1 replies) (more)2010 03 10
Inserting HTML data into MySQL - Basic logic questions :) (1 reply) (more)2010 03 10
How to repair corrupted table (no replies) (more)2010 03 10
Serious issue with stored proc function vs. procedure (5 replies) (more)2010 03 10
Multi Master Replication issue (no replies) (more)2010 03 10
Setting up new databases and accounts (-1 replies) (more)2010 03 10
Multi Master Replication issue (-1 replies) (more)2010 03 10
Setting up new databases and accounts (no replies) (more)2010 03 10
MissingManifestResourceException (no replies) (more)2010 03 10
Sr. MySQL DBA | ReachLocal | Los Angeles, CA (no replies) (more)2010 03 10
MissingManifestResourceException .NET (1 reply) (more)2010 03 10
Mysql with Php (no replies) (more)2010 03 10
Restore of Small Database Taking Way Too Long (1 reply) (more)2010 03 10
Complete Noob, in need of help/coaching (1 reply) (more)2010 03 10
iot table (no replies) (more)2010 03 10
CREATE PROCEDURE/FUNCTION problems (no replies) (more)2010 03 10
Getting java.sql.SQLException: Operation not allowed after ResultSet closed (more)2010 03 10
Webinar: Secrets of Successful SaaS Database Architecture with Tungsten (no (more)2010 03 10
Slow Queries - .NET & ODBC after 3.51.12 (no replies) (more)2010 03 10
Webinar: Secrets of Successful SaaS Database Architecture with Tungsten (no (more)2010 03 10
Webinar: Secrets of Successful SaaS Database Architecture with Tungsten (no (more)2010 03 10
How to create a treeview of MYSQL database (no replies) (more)2010 03 10
Multi Master Replication issue (no replies) (more)2010 03 10
SQL Question -> Forward SQL Engineer create script (no replies) (more)2010 03 10
Merge 3 diferent querys for Orders in Oscommerce (no replies) (more)2010 03 10
A cursor within a trigger (no replies) (more)2010 03 10
MySQL startup problem (no replies) (more)2010 03 10
Configuring mysql on windows vista (no replies) (more)2010 03 10
Adding new rows while editing table data (1 reply) (more)2010 03 10
Restore problem (no replies) (more)2010 03 10
Auto Incrementing values in one column while another has the same value (1 (more)2010 03 10
MS Word does not work with a QUERY VIEW (1 reply) (more)2010 03 10
How to ignore error 1086 (file already exists)? (3 replies) (more)2010 03 10
How to create cron job in localserver using php and mysql (no replies) (more)2010 03 10
create table with two timestamp values (1 reply) (more)2010 03 10
what is the equivalent of MS Access Query object in MYSQL? (1 reply) (more)2010 03 10
which table needs repair? (no replies) (more)2010 03 10
Slow COUNT query (3 replies) (more)2010 03 10
MySQL SELECT query block other applications (no replies) (more)2010 03 10
Indexing large amount of columns with varied queries (no replies) (more)2010 03 10
Managing data on real time basis (no replies) (more)2010 03 10
jdbc character sets and collate (no replies) (more)2010 03 10
Previous Page - Next Page  


HDLNS (dot com) - News Headlines Updated 24 Hours a Day.
"HDLNS (dot com)" is a trademark of Avant Garde Creatives, Inc. This site, its design, and all associated software © 2005, Avant Garde Creatives, Inc. All rights reserved. All content is provided for your personal, non-commercial use, in accordance with the terms of its providers.
HDLNS (dot com) is search engine sitemap friendly. Classifieds