Jump to content

  • Log In with Google      Sign In   
  • Create Account

Awesome job so far everyone! Please give us your feedback on how our article efforts are going. We still need more finished articles for our May contest theme: Remake the Classics

Uthman

Member Since 11 Jan 2000
Offline Last Active Jan 07 2013 12:55 AM
-----

Topics I've Started

simple sql question

23 December 2012 - 08:55 PM

Q1: Regarding indexing foreign keys on InnoDB

Is this required? Is it a best practice?

 

Q2: If the answer to Q1 is `Yes`, what about if I have two FK's and I only ever reference them at the same time--should I create individual indices along with the group index, or would the group index suffice?

 

EG: Table name = Object

Object has two FK's: User1, User2

 

I only ever access the table while searching using WHERE User1='' AND User2=''.

 

Any incites from gd's sql gurus would be much appreciated and ++thanks in advance.


visited this site daily

17 May 2012 - 08:17 PM

by a show of hands, how many of you frequented this site daily, back in the year? and how many of you have entries on it? =)

Android WebView

01 February 2012 - 03:28 PM

I'm programming a small Android app. It's basically an HTML5 jQueryMobile application displayed in an Android WebView. I noticed that jQM's rounded corner CSS for input elements gets all funky and pixelated in the WebView (even when zoom is disabled). This artification is also present when I view my pages within Android's default browser.

When I view my pages on a regular machine or even on Firefox mobile / opera mini, they render properly. Here are some screenshots taken from my device. The one on the left is from the web view.

Is there any way to get the webview to render the CSS properly / get better quality?

Posted Image

PARTNERS