How to speed up select count(*) with group by? It's too slow and is used very frequently. I have a big trouble using select count(*) and group by with a table having more than 3,000,000 rows. select object_title,count(*) as hot_num from relations where relation_title='XXXX' group by object_title relation_title, object_title i...
how can we count space between text in php ? example: hi how are you? spaces: 3 is there any way to count spaces ? Language : Only PHP ...
mysql> select count(*) from table where relation_title='xxxxxxxxx'; +----------+ | count(*) | +----------+ | 1291958 | +----------+ mysql> explain select * from table where relation_title='xxxxxxxxx'; +----+-------------+---------+- | id | select_type | rows | +----+-------------+---------+- | 1 | SIMPLE | 1274785 | +---...
Hi all, For a C# regression test simulation of some hardware we're using log4net to trace the execution of the simulation. Errors are logged every time something goes wrong, and there should be zero errors, of course. We use the error count to determine pass/fail of the test, currently we search the log for ERROR to determine this. I...
howdy! I can get row count from system table in db2 using select tabname,card from syscat.tables where tabname='?' but this will give static row count,If I need to get dynamic one I need to run runstats on the table. is there any other way apart from using count(*) ? Cheers, Prateek ...
I want a "group by and count" command in sqlalchemy. How can I do this? ...
I have an artist table and a style table. artist table: id name styleid style table id name An artist has a style id I'm trying to return a style summary which includes style id, style name and number of artists belonging to that style. I've got the following statement which gets me the id and number of artists but I cant see how...
I have this table called Online_Transaction and i want to show all the types of transactions and how many where made of each type (completed,rejected,pending for authorization) in a specific month. I have this query until now but I get repeated results any ideas? SELECT DISTINCT TRANSACTION_TYPE_ID , YEAR(CREATED_ON) AS YEAR , ...
Hi there, I manage a J2EE application which is deployed on JBoss 3.2.1. As part of my service to my client I want to provide reports which show the number of active sessions. I have implemented a simple class and a JSP page which retrieve the number of active sessions, but I have discovered a flaw: the process of checking the number o...
i have a sql query: select id, name from table order by name result looks like this: 52 arnold 33 berta 34 chris 47 doris 52 emil for a given id=47 how can i determine the position in the result set? the result should be 4 because: 52 arnold 33 berta 34 chris are before (47, doris) and id=41 is on the 4th position in the resu...
I would like to develop a Forum from scratch, with special needs and customization. I would like to prepare my forum for intensive usage and wondering how to cache things like User posts count and User replies count. Having only three tables, tblForum, tblForumTopics, tblForumReplies, what is the best approach of cache the User topics ...
I have a command (cmd1) that greps through a log file to filter out a set of numbers. the numbers are in random order, so i use sort -gr to get a reverse sorted list of numbers. there may be duplicates within this sorted list. I need to find the count for each unique number in that list. For e.g. if the output of cmd1 is 100 100 ...
Hi, I have a table with a varchar(255) field. I want to get (via a query, function, or SP) the number of occurences of each word in a group of rows from this table. If there are 2 rows with these fields: "I like to eat bananas" "I don't like to eat like a monkey" I want to get word | count() --------------- like 3 ...
Hi, I want to combine three tables - date, lead and click - in a query. The tables looks like this: date: |date| lead: id|time|commission click: id|time|commission The table date is just storing dates and is used when getting dates with no click or lead. So if we have the following data in the tables: date: 2009-06-01 200...
Hi there, I am trying to figure out the most straightforward and safe way to count the number of active sessions using a memcached storage option. With DB based session storage, I can just count the number of rows in the table but can't do the same thing with memcached. Thanks, Vikram ...
Hi guys...please help me, i'm really struggling with this... Authors can write post, and authors can love other authors' posts... So posts belong to author (when authors write them), but posts habtm authors (when authors love them). For example i'd like to get posts ordered by number of postlovers and created in the last 24 hours. He...
I want to write a T-SQL query which returns not only the maximum value, but the number of rows having the maximum value. There must be a better way than what I have come up with --wrong way select LibraryBranchId, max(daysCheckedOut), count(daysCheckedOut) from books group by LibraryBranchId LibraryBranchId Expr1 Expr2 -...
Hi, I'm trying to create a simple image gallery, showing 16 images per page. I'm using LIMIT 16 to display the correct amount on the page, but if there are more than 16 rows, I want to have links at the bottom, allowing the user to navigate to the next page. I know I could achieve the desired result by removing the limit and simply u...
I have the following query, which is trying to figure out the percentage of a certain product compared to the total number of products. IE: [Product Count] / [Total Products] = Percent ;WITH totalCount AS( SELECT CAST(COUNT(id) as Integer)as totalCount FROM TABLE_NAME ) SELECT ((CAST(COUNT(DISTINCT id) as Integer)/(SE...
How can I find the number CPUs on 64 bit window 2003 servers? The answers in this thread did not work. Using Win32_ComputerSystem.NumberOfProcessors returns none. I would prefer a way to do it using WMI if possible. I have a script that already his all the machines I need this info from grabbing disk info. Thanks ...