Search Results

Search found 28593 results on 1144 pages for 'best pratices'.

facebook twitter digg google delicious technorati stumbleupon myspace wordpress linkedin gmail igoogle windows live tumblr viadeo yahoo buzz yahoo mail yahoo bookmarks favorites email print

Page 535/1144 | < Previous Page | 531 532 533 534 535 536 537 538 539 540 541 542  | Next Page >

  • Deleting huge chunks of data from mysql innodb

    - by ming yeow
    I need to delete a huge chunk of my data in my production database, which runs about 100GB in size. If possible, i would like to minimize my downtime. My selection criteria for deleting is likely to be DELETE * FROM POSTING WHERE USER.ID=5 AND UPDATED_AT<100 What is the best way to delete it? Build an index? Write a sequential script that deletes via paginating through the rows 1000 at a time?

    Read the article

  • Get text from listview onclick (Android)

    - by dweebsonduty
    I am creating lists in my android app and would like to capture the text of the list item that is clicked but I want to do it in a seperate function so I only have to write the code once. And I want to be able to compare the string to another sting. What is the best way to do this?

    Read the article

  • In MySQL, what is the most effective query design for joining large tables with many to many relatio

    - by lighthouse65
    In our application, we collect data on automotive engine performance -- basically source data on engine performance based on the engine type, the vehicle running it and the engine design. Currently, the basis for new row inserts is an engine on-off period; we monitor performance variables based on a change in engine state from active to inactive and vice versa. The related engineState table looks like this: +---------+-----------+---------------+---------------------+---------------------+-----------------+ | vehicle | engine | engine_state | state_start_time | state_end_time | engine_variable | +---------+-----------+---------------+---------------------+---------------------+-----------------+ | 080025 | E01 | active | 2008-01-24 16:19:15 | 2008-01-24 16:24:45 | 720 | | 080028 | E02 | inactive | 2008-01-24 16:19:25 | 2008-01-24 16:22:17 | 304 | +---------+-----------+---------------+---------------------+---------------------+-----------------+ For a specific analysis, we would like to analyze table content based on a row granularity of minutes, rather than the current basis of active / inactive engine state. For this, we are thinking of creating a simple productionMinute table with a row for each minute in the period we are analyzing and joining the productionMinute and engineEvent tables on the date-time columns in each table. So if our period of analysis is from 2009-12-01 to 2010-02-28, we would create a new table with 129,600 rows, one for each minute of each day for that three-month period. The first few rows of the productionMinute table: +---------------------+ | production_minute | +---------------------+ | 2009-12-01 00:00 | | 2009-12-01 00:01 | | 2009-12-01 00:02 | | 2009-12-01 00:03 | +---------------------+ The join between the tables would be engineState AS es LEFT JOIN productionMinute AS pm ON es.state_start_time <= pm.production_minute AND pm.production_minute <= es.event_end_time. This join, however, brings up multiple environmental issues: The engineState table has 5 million rows and the productionMinute table has 130,000 rows When an engineState row spans more than one minute (i.e. the difference between es.state_start_time and es.state_end_time is greater than one minute), as is the case in the example above, there are multiple productionMinute table rows that join to a single engineState table row When there is more than one engine in operation during any given minute, also as per the example above, multiple engineState table rows join to a single productionMinute row In testing our logic and using only a small table extract (one day rather than 3 months, for the productionMinute table) the query takes over an hour to generate. In researching this item in order to improve performance so that it would be feasible to query three months of data, our thoughts were to create a temporary table from the engineEvent one, eliminating any table data that is not critical for the analysis, and joining the temporary table to the productionMinute table. We are also planning on experimenting with different joins -- specifically an inner join -- to see if that would improve performance. What is the best query design for joining tables with the many:many relationship between the join predicates as outlined above? What is the best join type (left / right, inner)?

    Read the article

  • Books on hiring technical people?

    - by Mark Gibaud
    I've just finished reading "Smart, and Gets Things Done" and while entertaining and byte-sized ;-) I found it a little US-centric and slightly less applicable to workplaces that are "only" above-average instead of rockstar--at-work places. I'm looking for more books on how to hire technical people. The only other one that has been recommended is Hiring the Best Knowledge Workers... Can anyone recommend any more?

    Read the article

  • jQuery set ajax return value in form field

    - by stef
    I've always used ajax to load() the contents of a DOM element but now I'm trying set a form field value with the result of the following query: $('#form_field').load(base_url+'ajax/get_yearly_fee', { 'q_value': $(this).val(), 'client_id': $("#fee_client_add").val() }); What's the best way to do this?

    Read the article

  • Data migration from site5 to heroku

    - by Denis
    Hi, I've a Rails 2.1.2 App hosted on site 5. This App is running since 2 years and I want to migrate the site on heroku. No pb to install the site on heroku, but what about the data?! What is the best strategy to export from site 5 (I've phpMyAdmin) and then import to heroku? Thanks

    Read the article

  • Heterogeneous NSTreeController

    - by andyvn22
    I have an NSTreeController (supplying content to an NSOutlineView). I'd like the top-level objects to be of one class, and all other objects (so, children at any level) to be of another. What's the best way to go about this? I'll need to somehow change the behavior of at least add, addChild, insert, and insertChild, I suppose. I was hoping, though, to find a simple way to account for this in only one location, rather than changing four separate methods.

    Read the article

  • Re-using Buttons in WPF

    - by Alex Marshall
    I have a bunch of different objects that are commonly edited in the same TabControl using different DataTemplates, but I want each DataTemplate to have a common look and feel with Ok and Cancel buttons at the bottom right of each tab that will close the tab or save the content and then close the currently selected tab. What's the best way to place buttons on each tab ? Is there a way to do it without copying and pasting the buttons and stack panel across all of my data templates ?

    Read the article

  • WPF image zooming

    - by anwar
    WPF: What is the best way to implement Zoom In and Zoom Out option for an Image inside ScrollViewer in WPF at runtime and also other alternative methods for the same Please provide sample code and suggest links where I can find sample code and more info about various ways to Zoom the image. Regards, Anwar

    Read the article

  • Regex solution for Objective-C

    - by rjstelling
    What is the best method for using Regular Expressions within Objective-C? There seems to be some open source project that provide regex support, can any one recommend one? Also I looked at NSPredicate, can anyone suggest any regex examples? Background: I want use regex mainly for validation, IP's, email addresses, internal ID's etc

    Read the article

  • I need to modify the code of a third-party gem, where and how to do?

    - by Freewind
    I'm building a website based on RoR, and using a third-party gem "devise". I have used rake gems:unpack to unpack the "devise" to my "vendor/gems" directory. Now, I found the method "SessionsController.create" provided by "devise" is not fit my requirement, and I want to modify it. But I don't know what it is best way: just modify the method SessionsController.create" directly? create another SessionsController and override the "create" method?

    Read the article

  • Remove characters with regex in c#

    - by Rise_against
    Hello all, I am not a regex specialist, so I need some help with this. I have a text file, and I need to remove some trailing delimiters. The text file looks like this: MSH|^~\&|OAZIS||||20101029135359||ADT^A31|00000015|P|2.3.1||||||ASCII EVN|A31|20101029135359^^^^||||19900101 So I think the best way is to do a Regex replace? Can anyone help me with this regex? I want to remove all ^ that come before a | So test^A^^| has to become test^A| Thanks

    Read the article

  • Creating a new wordpress post from twitter tweets

    - by pingu
    Hi guys, I'd like to build an application that, on interval, it checks for tweets containing a particular hashtag, and creates an individual Wordpress post for each tweet that it finds. What is the best way to do this? Are there existing plugins/tools available, or should I write my own custom plugin?

    Read the article

  • URL-&coordinate based screen capturing tool

    - by Enrico Stahn
    Hello, I'm searching for a screen capturing tool which captures areas of an website/web-application based on the url. The very best for me would be an firefox/ie addon with an API accessible via javascript. Example: URL, Coordinates, Filename http://foo.com/project/show/33; rectangle:10,10,50,50; myapp-area1.jpg http://foo.com/project/show/33; rectangle:100,100,150,150; myapp-area2.jpg

    Read the article

  • How can I compile an iPhone App with Flash CS5 without a Developer License

    - by manderson12
    I understand Flash CS5 isn't the best way to make an app, but I'd really like to test out the apps I've made with it on my iPhone. Has anyone come up with a way to modify Flash CS5 so it doesn't require a Developer Certificate or Provisioning Profile (like the way you would modify Xcode so you can compile apps without paying $99 for the developer program)? I'd really appreciate it if anyone could provide some help. Thanks in advance.

    Read the article

  • question about sorting

    - by skydoor
    Bubble sort is O(n) at best, O(n^2) at worst, and its memory usage is O(1) . Merge sort is always O(n log n), but its memory usage is O(n). Which algorithm we would use to implement a function that takes an array of integers and returns the max integer in the collection, assuming that the length of the array is less than 1000. What if the array length is greater than 1000?

    Read the article

  • Store username and password persistent in windows mobile(6.0) app

    - by Stefan
    Hi I need some help developing my mobile app. I have to store user data permant (name, password), so what is the best way to do that? I dont know a special API for it, so where to store persistent data's on a windows phone? Maybe in the win mobile registry or inside a file? Or should I use a light database? Someone has experience with this? thx, Stefan

    Read the article

  • Change User Password in ASP.NET Forms Authentication

    - by naveen
    Hi Guys, I code in C# (ASP.NET) and am using Forms authentication. I would like to know which is the best method to change a user password without using the asp:ChangePassword control. I dont want to use the reset password method. I just want to grab the password i have inside my textbox and replace it with my older password. Please note that the PasswordFormat I use is passwordFormat="Hashed" Some code snippets would be helpful Regards, Naveen Jose

    Read the article

  • Codeigniter multilanguage and adding the language to the url for seo

    - by Jayapal Chandran
    Hi, I read this http://stackoverflow.com/questions/1328420/the-best-way-to-make-codeigniter-website-multi-language-calling-from-lang-arrays for language inclusion... i wonder how the url will appear for multi languages... How to show the language in url so that it will also be indexed in search engines... for example sitenameDOTcom/es or sitenameDOTcom/whoweare/es or something like this and how to sync with the controllers and the urls...

    Read the article

facebook twitter digg google delicious technorati stumbleupon myspace wordpress linkedin gmail igoogle windows live tumblr viadeo yahoo buzz yahoo mail yahoo bookmarks favorites email print

< Previous Page | 531 532 533 534 535 536 537 538 539 540 541 542  | Next Page >