skip to main | skip to sidebar

CS Reference

Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts

Monday, November 1, 2010

SQL Queries

Optimizing SQL: Removing queries inside loops

MySQL Paginated displays

How to search a string value in all columns in the table and in all tables in the database
Posted by whiteshark at 11:31 AM No comments:
Labels: Performance, Queries, SQL
Older Posts Home
Subscribe to: Posts (Atom)

University Courses & Opensource

  • Algorithms
  • Berkeley - Efficient Algorithms and Intractable Problems
  • Calculus Online
  • Capilano University OpenCourseWare - Canada
  • Cavendish Laboratory, Cambridge - Information Theory, Inference, and Learning Algorithms
  • Center For Networked Systems - UCSanDiego
  • Collection Of STM Books, Journals and reference Work
  • Computer Science
  • Computer Science Paper Collection
  • Cornell University Library
  • CS Theory @ Princeton - US
  • Data Mining and Applications Graduate Certificate
  • Data Structures
  • Data Structures, Algorithms, and Applications in Java
  • Department Of Comp. Science - Maryland
  • Department of Computer Architecture
  • Elementary Statstics
  • Google Research
  • HiPEAC Compilation Architecture
  • HP Opensource
  • IntroToAlgorithms
  • Jikes RVM Compiler
  • Johns Hopkins Bloomberg School of Public Health - US
  • Khan Academy - Free Classroom For The World
  • Machine Learning: An Algorithmic Perspective
  • MIT OpenCourseWare - Introduction to Algorithms
  • MIT OpenCourseWare - US
  • Notre Dame OpenCourseWare - US
  • Openculture - Freeonline Courses
  • Opensource Intel
  • Opensource Mitre
  • Opensource Novell
  • Opensource Real Networks
  • Opensource Sybase
  • Opensource thoughtworks
  • Probabilistic Models - UC SanDiego
  • ProblemSetArchive
  • Software Carpentry
  • Stanford Engeneering SEE Program
  • Structure and Interpretation of Computer Programs
  • The C Programming Language - 2nd edition, Kernighan and Ritchie
  • The Elements of Statistical Learning
  • The Open University - United Kingdom
  • The UMass Boston OpenCourseWare - US
  • The University of Maryland
  • Tufts University - US
  • U San Diego - Advanced Compiler Design
  • UC Irvine Machine Learning Repository
  • UMass - Compiler Techniques
  • UMass - Natural Language Processing
  • University of California, Berkeley - US
  • University of California, Irvine - US
  • University of Edinburgh - Compiler Optimisation Lecture
  • University of Southern Queensland - Australia
  • Utah OpenCourseWare Alliance - US
  • Utah State University - US

Podcast, Webinar

  • Azul Systems - Webinar
  • Java Links
  • Python Micro Community
  • Ruby on Rails Screencasts
  • Skiena's Algorithms Lectures
  • Software Engineering Institute - Carnegie Mellon
  • The Java Posse - #1 Technology Podcase
  • Top Prospect
  • Vmware Events

Core Java & C++

  • Bjarne Stroustrup's C++ Style and Technique FAQ
  • C++-faq-lite
  • Core Java Problems and Solutions - Jakob Jenkov
  • Core Java Technologies Tech Tips
  • Data Structures - UC Berkeley
  • Java object serialization specification
  • Neal Gafter - Closure Java
  • Serialization and Java RMI
  • The Java Language Specification
  • The Java serialization algorithm revealed
  • Understanding WebLogic Server Application Classloading

Memory Management

  • Java Concurrency (&c)
    Lightweight Asynchronous Sampling Profiler
  • Java HotSpot Garbage Collection
  • JavaOne Technical Sessions - The Garbage-First Garbage Collector - 2008
  • Memory Management in the Java HotSpot Virtual Machine
  • The Java Memory Model - Jeremy Manson
  • Tuning Garbage Collection with the 5.0 Java[tm] Virtual Machine

Problems

  • Diamond Problem
  • Double-Checked Locking is Broken
  • Floating-Point Arithmetic
  • Game Of Life - Android, Java, HTML5
  • The N+1 Selects Problem

JVM(Java Virtual Machine)

  • Apache Harmony - Open Source Java SE
  • Guide to VM - Version covered till JDK 7.0
  • HotSpot Internals for OpenJDK
  • Java SE HotSpot at a Glance
  • Java x86 PC emulator
  • Know the JVM Series
  • Sun Wiki
  • The Java Language Specification, Third Edition
  • The Java Virtual Machine Specification - Books
  • Visual VM

Database

  • Mysql Performance Blog
  • Domas Mituzas

Web Technologies/Design

  • Bbackbone.js
  • Creating mobile Web applications with HTML 5
  • CSS3watch
  • Fast Co-Design
  • Graphic Paterns
  • Guardian Developer-blog
  • How To Node
  • HTML5 Tutorial
  • HTML5Demos
  • Intro to the Cache Manifest - HTML5
  • iScroll
  • Jo HTML5 Mobile App Framework
  • JQuery
  • Node Wiki
  • nodejs
  • Open Bixo - Web Mining
  • Python Webkit DOM Bindings
  • pywebsocketa - Web Socket extension for Apache HTTP Server, mod_pywebsocket
  • Remove onClick delay on webkit for iPhone
  • SeleniumHQ - Automate web app testing
  • Summer - The HTML5 Library for Java
  • The WebSocket API
  • TouchScroll Demo
  • V8 JavaScript Engine
  • Websocket Sample

Security/Hacking

  • I hack for fun
  • Anatomy Of Credit Card
  • Homemade GPS Receiver
  • Hacker Things
  • Schneier on Security

Android Tools

  • Android Asset Studio
  • Android Code Style Rules
  • Android UI Utilities
  • Draw 9-patch tool allows you to easily create a NinePatch graphic using a WYSIWYG editor
  • Pencil Project's - Build a free and opensource tool for making diagrams and GUI prototyping
  • User Interface (UI) designer/editor for programming the Android Cell Phone Platform

Tools, Packages, Framworks, Languages, References, Tutorials

  • A marketplace where you can easily discover and install mobile webapps on the WWW.
  • ACM Magazines
  • Analytics - Flurry
  • Android
  • Arduino based Office-WTF-Counter
  • Arduino is an open-source electronics prototyping platform
  • clang: a C language family frontend for LLVM
  • Closure Tools
  • Collabedit is a collaborative text editor
  • Dalvik Virtual Machine
  • Epsilon - Java library for monitoring of Java application performance and latency
  • Github Tutorial
  • High-quality legal docs to get your startup started
  • JQuery plugin for mobile web development on the iPhone
  • JSON
  • Lynx
  • Mechanical Sympathy
  • Network Protocol Analyzer
  • NGINX - HTTP server
  • Open Group
  • PhoneGap is an open source development framework for building cross-platform mobile apps.
  • plovr: a Closure build tool
  • Python Library for Google Analytics Management API
  • Read Ruby
  • Safari Reference Library
  • Sencha - Develop amazing apps built on web standards
  • SoyLatte: Java 6 Port for Mac OS X 10.4 and 10.5 (Intel)
  • Start SSL
  • The Haskell Platform
  • The LLVM Compiler Infrastructure
  • Web Services Interoperability Technologies (WSIT)
  • WebKit

Learn Spoken Languages

  • TV Germany
  • German Language Knowledge
  • German Programmed Introduction Course
  • Learn everything about Germany!
  • German perfect podcast
  • LINK TO GERMANY
  • TV Germany

Study Group

  • NYC Java

Companies

  • Venture Fizz - Resources
  • Buy and Sell Shares of Leading Venture-Backed Companies

Maths & Stats

  • Google Publications
  • Linked Data
  • Linking Open Government Data
  • Lkeio - Semantic Information Retrieval
  • NACTA+
  • National Centre for Text Mining
  • Public Sector Data - Data.gov
  • Tetherless World Constellation at RPI
  • Without Geometry, Life is Pointless

Tech Blogs

  • A. Dzone.com - Links
    Beginners tutorial on implementing persistence with JPA
    10 years ago
  • AI and Social Science - Brendan O'Connor - Cognition, systems, decisions, visualization, machine learning
    Replot: departure delays vs flight time speed-up
    11 years ago
  • Ajaxian » Front Page
    3 Areas of Improvement to Drive Channel Marketing Success
    2 years ago
  • Apache Lucene - Changing Bits
    Concurrent query execution in Apache Lucene
    5 years ago
  • Apple - John Gruber
    iPhones 17 and the Sugar Water Trap
    2 days ago
  • Art & Science - A broader view
    This blog has moved!
    10 years ago
  • Business, Technology, Finance - 6 AM Pacific
    Self-driving Cars in India
    8 years ago
  • Chromium Blog
    Introducing Skia Graphite: Chrome's rasterization backend for the future
    2 months ago
  • Cthulhu and other crazies
    How to go from Senior to Lead
    1 year ago
  • Doug Lea's Home Page
  • Ehcache - Greg Luck's Blog - CTO Terracotta
    Using sun.misc.Unsafe in Java 9
    8 years ago
  • Feature Stories About Java Technology
  • GarfieldTech - Technical thoughts, tutorials, and musings
    A survey of data modeling
    3 weeks ago
  • Google Wave Developer Blog
    Introducing Apache Wave
    14 years ago
  • Hibernate - In Relation To - Gavin
    Hibernate Search 8.1.2.Final is out
    4 days ago
  • High Scalability
    Highscalability is Up For Sale
    1 year ago
  • IBM - A Smarter Planet Blog
    Making the workplace safe for employees living with HIV
    4 years ago
  • iPhone Development
    WWDC 2014
    11 years ago
  • James Gosming - On a New Road
    I haven't disappeared...
    12 years ago
  • Java - Alain Defrance's Blog
    The documentation problem
    9 years ago
  • Java - Geertjan's Blog
  • Java - The Aquarium
  • Java - Twisters - The New Age Java Quiz
    Javachats - My Personal Blog
    13 years ago
  • Java, Spring - @Blog("Baptiste Wicht")
    Trying out Rust and C++26
    3 months ago
  • JavaWorld's Daily Brew blogs
  • Jawher's Blog
    newBlog.promo(1, “nginx, python, uwsgi”)
    13 years ago
  • Jim Webber - ThoughtWorks
  • Jonathan Gibbons
  • Joseph D. Darcy's Oracle Weblog
  • Kelly O'Hair's Weblog (blogs.sun.com)
  • kung fu grippe
    The track order should have been exactly reversed and that is...
    1 year ago
  • Magpiebrain - Sam Newman - Consultant at ThoughtWorks
    Speaking at Goto: Aarhus 2012 Next Week
    12 years ago
  • Mkyong.com - Framework Tutorials
    Tabletki na Powiększanie Penisa - Ranking Produktów 2023
    2 years ago
  • Mobile Analytics, Simplified.
    So Long ... But Not Goodbye.
    13 years ago
  • myNoSQL
    Autoscaling, welcome to Google Compute Engine
    10 years ago
  • Node.js, web - Debuggable.com
    Releasing node-mysql 2.0.0-alpha
    13 years ago
  • O'Reilly Radar - Insight, analysis, and research about emerging technologies.
    Taming Chaos with Antifragile GenAI Architecture
    2 days ago
  • Peteris Krumin - Good coders code, great reuse
    Try Cross-browser Testing! (For Free!)
    1 week ago
  • Python - Michael G. Noll
  • Python Cloud DB
    Reviving the Ancient Game of Liubo 六博 as an HTML5 Multiplayer App with Google AppEngine on Python and the Channel API
    14 years ago
  • Quant Articles, Financial Engineering Articles
  • Rands In Repose
    The One about Bingeworthy Shows
    4 years ago
  • Scrum and Agile Blog - CollabNet
    Have you Taken the State of Agile Survey? Deadline Extended to the End of the Year
    6 years ago
  • Software - Blue Sky On Mars
    Stupid Security Things
    8 years ago
  • Software Hardware - Robot is Happy
    Pahami! Begini Proses Konstruksi Jalan Aspal
    2 years ago
  • SpringSource Team Blog
  • SQL - Django-nonrel & webdev blog
  • Sun Bloggers
  • Tech & Innovation - Xconomy
    Watch ‘Jesus Revolution’ (Free) Online Streaming HBO Here’s How!
    2 years ago
  • Tech - Alexis Ohanian - Soaring on a Pig with Bread Wings
    I'm back. Fully Initialized.
    7 years ago
  • Tech, Startup & Innovation - Don Dodge on The Next Big Thing
    Facebook 100 years from now
    8 years ago
  • The programmer's notes
    Java By Comparison: the book review
    6 years ago
  • Time To Get Back To Reality - Bill Lee
    I love my Bitcoin clock!!! Thank you @matthewzipkin
    8 years ago
  • Web Services - Francois Lascelles's Blog
    Common OAuth Security Mistakes & Threat Mitigations
    11 years ago
  • WebKitBits - David Kaneda - Creative director Sencha
    WebKit for Developers
    12 years ago
  • Webzine - Create Digital Motion
    Daedelus and Takuma Matsui talk Tinge, a painterly color wheel arpeggiator
    3 hours ago
  • Yahoo! User Interface Blog
  • Cassandra, EC2 - Geekout
    Earnstone Sharded Column Index for Cassandra
    14 years ago

Twitter

  • #Nodejs

JavaOne Online Technical Sessions

  • Channel Sun
  • JavaOne - 2007
  • JavaOne - 2008
  • JavaOne - 2009
  • JavaOne - 2010
  • Techcast

Technology & Inovation

  • AccuTracking software turns phones into a GPS tracking device
  • CHDK firmware add-on for Canon's Digic II, Digic III and Digic IV cameras
  • Critical Perspective On Current And Emerging Technologies
  • Gadget.brando
  • GPSLocator
  • InstaMapper tracks a GPS-enabled cell phone online in real time
  • Jammerstore
  • Jobs Trend
  • John Ghram-Cumming
  • MIT Experiment - Pictures from space
  • Question Everything - George Mobus
  • Thejammerstore
  • Tinker Nut - Hacks & Stuff
  • Tracking change and innovation in the enterprise software development community
  • XIPH - Support & Develop Free, Open Protocols & Software

VC Bloggers

  • A VC
    I’ve Moved Onchain
    1 year ago
  • abovethecrowd.com
    Venture Capital Red Flag Checklist
    2 years ago
  • AKF Partners Blog
    AKF Turns 10 – And It’s Still Not About the Tech
    8 years ago
  • Ask The VC
    How To Install IPTV On Your Android, iPhone Or iPad
    3 years ago
  • Back of the Envelope | Jonathan Wegener's Technology/Marketing Blog
    A letter to my younger self: big things start small
    7 months ago
  • BeyondVC
    boldstart ventures in 2014 – our ethos
    11 years ago
  • blog.pmarca.com
    The Pmarca Blog Archive Is Back… as an Ebook
    10 years ago
  • EarlyStageVC
  • Feld Thoughts
    Reid Hoffman’s Superagency
    19 hours ago
  • How to Change the World
    Dr. Vivek Murthy
    4 years ago
  • Life With Alacrity
    The Path to Self-Sovereign Identity
    9 years ago
  • Lightspeed Venture Partners Blog
    Data Beats Math –Why Apple’s Maps Failure is a Big Data Problem
    12 years ago
  • Master of 500 Hats
    Dave is now blogging at 500hats.com
    13 years ago
  • Only Once - Matt Blumberg
    Announcing the launch of the Startup CXO mini-books for CFOs, CROs, CMOs, CTOs, and CPOs
    4 months ago
  • Redeye VC
    WhatsApp Used This Pricing Strategy to Win and You Can Too
    10 years ago
  • Seeing Both Sides
    Reminder: Seeing Both Sides is at a New Location
    6 years ago
  • Seth Levine's VC Adventure
    You May Have Too Many VCs On Your Board
    7 years ago
  • Startup Boy
    Get in The Ring
    2 weeks ago
  • Tech & Innovation - Innovation Economy
    How Cambridge became the life sciences capital
    9 years ago
  • The Post Money Value
    Haiti Relief App by Xtreme Labs
    15 years ago
  • Tim Oren's Due Diligence
    A Family History Interlude
    14 years ago
  • Union Square Ventures: A New York Venture Capital Fund Focused on Early Stage & Startup Investing
    Top Hat
    8 years ago
  • VC in DC
    Video of my 2013 JMU College of Business Commencement Address
    12 years ago
  • VCMike's Blog
    I Am Thankful
    13 years ago
  • Venture Maven - RSS Feed
  • VentureBlog
  • VentureFizz - Resources
  • Who Has Time For This?
    Investment Recommendation: Claroty Series A
    9 years ago

Labels

  • Agile (1)
  • Algorithm (4)
  • Android (5)
  • App-Engine (2)
  • Apple (1)
  • Approach (1)
  • Architectures (17)
  • Arithmetic (1)
  • Articles (2)
  • Assembly (1)
  • Bayesian (1)
  • C++ (1)
  • C++: Rcpp (2)
  • Cassandra (1)
  • Clojure (2)
  • Closure (2)
  • Cloud (1)
  • Concurrency (2)
  • CouchDB (1)
  • CUBRID (1)
  • Data Structure (2)
  • EC2 (1)
  • Eclipse (1)
  • Forth (1)
  • Geospatial (1)
  • Git (3)
  • Go (1)
  • Google (5)
  • Gradle (1)
  • Grails (2)
  • Groovy (1)
  • Guava (1)
  • Hardware Architecture (1)
  • Hibernate (3)
  • HTML5 (2)
  • HTTP (1)
  • Internals (1)
  • Interview (4)
  • iPhone (1)
  • Java (5)
  • Javascript (1)
  • jQuery (2)
  • JVM (1)
  • Kode (1)
  • Linux (4)
  • Location Aware (1)
  • Machine Learning (1)
  • Markov Chain Monte Carlo (1)
  • Math (1)
  • Maven (1)
  • MCMC (1)
  • Memory Management (1)
  • Mobile (1)
  • MongoDB (1)
  • MySQL (1)
  • Neo4j (1)
  • Node.js (2)
  • NOSQL (1)
  • NumPy (1)
  • Obj-C (1)
  • OpenGL (1)
  • Oracle (1)
  • OSGi (1)
  • Parser (1)
  • Performance (1)
  • PHP (1)
  • Problems (1)
  • Programming (13)
  • PyMC (1)
  • Python (7)
  • Queries (1)
  • R (7)
  • Realtime (1)
  • Redis (2)
  • REST (2)
  • RInside (2)
  • RProtobuf (2)
  • Ruby (4)
  • Ruby On Rails (1)
  • S (1)
  • Scala (1)
  • SCM (1)
  • Scratch (1)
  • Scrum (1)
  • Social (1)
  • Solaris (1)
  • Spring (1)
  • SQL (1)
  • Startup (2)
  • TCP/IP (1)
  • TED (5)
  • Ubuntu (1)
  • Unix (2)
  • Video (1)
  • VIM (1)
  • Visual Studio 2010 (1)
  • Voldemort (1)
  • Web (2)
  • Web Business (1)
  • Web service (1)
  • Webservice (2)
  • Windows Phone 7 (1)

Blog Archive

  • ▼  2015 (1)
    • ▼  April (1)
      • Links
  • ►  2012 (5)
    • ►  January (5)
  • ►  2011 (28)
    • ►  October (3)
    • ►  July (2)
    • ►  April (6)
    • ►  March (5)
    • ►  February (6)
    • ►  January (6)
  • ►  2010 (76)
    • ►  December (10)
    • ►  November (26)
    • ►  October (24)
    • ►  September (4)
    • ►  January (12)
  • ►  2009 (28)
    • ►  December (23)
    • ►  November (1)
    • ►  August (4)