Patrick

less info

network profile

826 reputation

11020

bio	website	techore.com
	location	Atlanta, GA
	age	32
visits	member for	2 years, 5 months
	seen	Jun 1 at 21:01
stats	profile views	40

PHP web developer for sharecare, maker of medical Q&A sites.

summary answers questions tags badges favorites bounties reputation activity

13 Questions

votes activity newest

43	How can I optimize a mysqldump of a large database?
11	In MySQL, does the order of the columns in a WHERE clause affect query performance?
7	MySQL InnoDB crash post-mortem
7	Alternative Database Tools for Web Admin
6	How long is “too long” for MySQL Connections to sleep?

view more

826 Reputation

+5	In MySQL, does the order of the columns in a WHERE clause affect query performance?
+10	When to use NULL and when to use an empty string?
+15	How long is “too long” for MySQL Connections to sleep?
+5	How can I optimize a mysqldump of a large database?

view more

5 Answers

votes activity newest

7	What are the main differences between InnoDB and MyISAM?
6	What's a good way to add a PRIMARY KEY to a large InnoDB table?
3	When to use NULL and when to use an empty string?
3	How to structure a model to properly and efficiently represent tree-like data on relational databases?
2	Securing DB passwords

25 Tags

15 mysql × 13	3 empty-string
13 innodb × 6	3 erd
7 myisam	3 feature-comparison
6 primary-key	3 null
3 database-design × 2	3 relational

view more

14 Accounts

	Motor Vehicle Maintenance & Repair	1,621 rep	719
	Stack Overflow	1,538 rep	820
	Programmers	1,090 rep	515
	Super User	930 rep	718
	Database Administrators	826 rep	11020

20 Badges

recent class name

Popular Question × 7	Famous Question
Notable Question × 4	Caucus
Favorite Question	Nice Question × 2
Yearling × 2	Taxonomist
Custodian	Good Question

view more

0 Active bounties

active offered earned

This user has no active bounties

14 Votes Cast

all time			by type
14	up		0	question
0	down		14	answer

Technology			Life / Arts	Culture / Recreation	Science	Other
Stack Overflow Server Fault Super User Web Applications Ask Ubuntu Webmasters Game Development TeX - LaTeX	Programmers Unix & Linux Ask Different (Apple) WordPress Answers Geographic Information Systems Electrical Engineering Android Enthusiasts IT Security	Database Administrators Drupal Answers SharePoint User Experience Mathematica more (14)	Photography Science Fiction & Fantasy Seasoned Advice (cooking) Home Improvement more (13)	English Language & Usage Skeptics Mi Yodeya (Judaism) Travel Christianity Arqade (gaming) Bicycles Role-playing Games more (21)	Mathematics Cross Validated (stats) Theoretical Computer Science Physics more (7)	Stack Apps Meta Stack Overflow Area 51 Stack Overflow Careers

site design / logo © 2013 stack exchange inc; user contributions licensed under cc-wiki with attribution required

rev 2013.6.19.749

Database Administrators Stack Exchange works best with JavaScript enabled