Search Results

Search found 18713 results on 749 pages for 'suggestions wanted'.

Page 225/749 | < Previous Page | 221 222 223 224 225 226 227 228 229 230 231 232  | Next Page >

  • Calculating average (AVG) and grouping by week on large data set takes too long

    - by caioiglesias
    I'm getting average prices by week on 7 million rows, it's taking around 30 seconds to get the job done. This is the simple query: SELECT AVG(price) as price, yearWEEK(FROM_UNIXTIME(timelog)) as week from pricehistory where timelog > $range and product_id = $id GROUP BY week The only week that actually gets data changed and is worth averaging every time is always the last one, so this calculation for the whole period is a waste of resources. I just wanted to know if mysql has a tool to help out on this.

    Read the article

  • Rotating blocks in JavaScript.

    - by Alvin SMith
    I'd like to create a JavaScript web app that makes blocks appear on the page that can be dragged around by the user. If I used DIVs with background colors, it would be easy to rotate them by 90 degrees at a time. However, if I wanted to rotate them arbitrarily, how could I accomplish this? I'd rather not have to resort to Flash, images, or HTML5.

    Read the article

  • how to get memory address

    - by levirg
    hey Folks, Is there any way in ruby to get the memory address of objects.. say.. (i = 5) is that possible to get the mem address of that object 5.. 'object_id_' is not that satisfying.. I just wanted to know how referencing to objects work on ruby, so i thought address will be useful, to get things done plugin memprof doesnt work on x_32bit, so is there any better way pls help me..., Any answer would be really appreciated... thanks, Regards levirg

    Read the article

  • Efficiently store last X items in an MySQL Database

    - by Saif Bechan
    I want to store the last 3 items in an MySQL database in an efficient way. So when the 4th item is stored the first should be deleted. The way I do this not is first run a query getting the items. Than check what I should do then insert/delete. There has to be a better way to do this. Any suggestions?

    Read the article

  • Looking to clean up a small ruby script.

    - by Badweather
    I'm looking for a much more idiomatic way to do the following little ruby script. File.open("channels.xml").each do |line| if line.match('(mms:\/\/{1}[a-zA-Z\.\d\/\w-]+)') puts line.match('(mms:\/\/{1}[a-zA-Z\.\d\/\w-]+)') end end Thanks in advance for any suggestions.

    Read the article

  • MySQL: how to index an "OR" clause

    - by JoséMi
    I'm executing the following query SELECT COUNT(*) FROM table WHERE field1='value' AND (field2 = 1000 OR field3 = 2000) There is one index over field1 and another composited over field2&field3. I see MySQL always selects the field1 index and then makes a join using the other two fields which is quite bad because it needs to join 146.000 rows. Suggestions on how to improve this? Thanks

    Read the article

  • How many keys are too many in memcached?

    - by jack
    I currently have about 650,000 items in memcached (430MB memory used) and the number is still increasing. It's expected to exceed 1,000,000 items before going flat. Current hit/miss ratio is 25:1 so the efficiency is pretty good. I just wanted to ask is one million items in memcached on single server too many? If no, how many is too many?

    Read the article

  • Good book for Flex 4?

    - by John Isaacks
    I read the O'Really Book: Programming Flex 3 and I thought it was awesome. I am now migrating to Flex 4 and wanted to read a great book for Flex 4. There are many Flex 4 books out there and I really just want to read 1 to get me up and running fast. So if anyone can share/recommend some books that would be great!

    Read the article

  • Qt 4.7 QtDeclarative headers

    - by bitc
    I installed Qt 4.7 beta on OS X. Then I wanted to try out the declarative module: The doc says #include <QtDeclarative> The Minehunt example says #include <qdeclarative.h> Neither is found! Most of the other header files are where they are supposed to be: /Library/Frameworks/Qt*.framework/Versions/4/Headers What do I do?

    Read the article

  • Using XMLHttpRequest ??

    - by Rohan
    Hey I'd like to know how to use XMLHttpRequest to load the content of a remote URL and have the HTML of the accessed site stored in a JS variable. Say, if I wanted to load and alert() the HTML of http://foo.com/bar.php, how would I do that? Thanks!

    Read the article

  • Getting scp's status bar to appear in a Java window

    - by pete
    I'm writing a program that uses scp to copy files in a bigger java program. As it stands now, the program freezes up while the scp is copying the file, which can take a few minutes, so I'd like to be able to display the progress of the scp or at the very least get the terminal window with the scp progress to show up! Any suggestions?

    Read the article

  • Can IDL create a contour plot colorbar like this?

    - by Carthage
    At the bottom of this image, you'll see a nice colorbar that matches the colors of the graph correctly: http://stribog.cc.umanitoba.ca/ceos/20100517_00z_prod/ I couldn't find anything that created a color bar with exactly the colors I wanted, it always seemed to involve a spectrum that included colors I didn't use. I have a vector of colors I use for my data. Is there I way I can use that vector to create a color bar with only those colors?

    Read the article

  • SQL Server, View using multiple select statements

    - by phil
    I've banging my head for hours, it seems simple enough, but here goes: I'd like to create a view using multiple select statements that outputs a Single record-set Example: CREATE VIEW dbo.TestDB AS SELECT X AS 'First' FROM The_Table WHERE The_Value = 'y' SELECT X AS 'Second' FROM The_Table WHERE The_Value = 'z' i wanted to output the following recordset: Column_1 | Column_2 'First' 'Second' any help would be greatly appreciated! -Thanks.

    Read the article

  • Open Source C/C++ embedded web server

    - by MGoDave
    I am working on a project where I need to embed a web server into my C++ application. I am looking for an open-source library supporting SSL, written in C or C++ and with a licensing scheme that will allow me to link it into my existing closed source code. Any suggestions of specific products or where to look first?

    Read the article

  • jQuery: have a child window be notified when parent window goes to a different page?

    - by Heinrich Schmetterling
    i have a parent window and a child window. in javascript, i want a function in child window to be called whenever the parent window loads a new page. i'd like to use something similar to jQuery's $(document).ready() so that I don't have to worry about whether the parent is done loading yet - but ready() only appears to fire when the window loads the first page - but not when, say, a link is clicked in the parent and it loads a second page. any suggestions? thanks.

    Read the article

  • Bypassing a requiredfieldvalidator

    - by Dave
    Hi, I have a webform which has validators on it that work well when the user presses the submit button. But when the user presses the logout button the validators stop that button from working. Any suggestions as to how remedy this?

    Read the article

  • Unicode filenames on windows in ruby

    - by delivarator
    I have a piece of code that looks like this: Dir.new(path).each do |entry| puts entry end The problem comes when I have a file named ???????.txt in the directory that I list. On a Windows 7 machine I get the output: ???????.txt From googling around, properly reading this filename on windows seems to be an impossible task. Any suggestions?

    Read the article

  • Undo implementation - DOM manipulations

    - by sonofdelphi
    Is there a library that can be used for implementing undo/redo functionality for DOM element manipulations in JavaScript? I'm writing an app that moves around DOM elements, enables editing and deletion of those elements. There are event-handlers and other objects associated with each element operated upon. Not sure whether I need to roll my own implementation of the Command pattern for this. Surely, there must be something available? If not, suggestions and pointers would be a great help.

    Read the article

  • How to create a mobile friendly website [infrastructure]

    - by Grant
    Hi, if i wanted to create a mobile friendly version of a relatively small website would it be better to have a sub domain that redirects to a completely new url with sperate markup and styling or would it be better to detect the useragent in code and programatically change to a different mobile friendly stylesheet, or is their a better infrastructure based solution i am overlooking.. Thanks.

    Read the article

< Previous Page | 221 222 223 224 225 226 227 228 229 230 231 232  | Next Page >