StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
1947941
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2009-12-22T17:31:48.973
FavoriteCount
0
LastActivityDate
2009-12-22T17:31:48.973
LastEditDate
LastEditorUserId
0
OwnerUserId
4833
ParentId
1947442
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
This is a perfect opportunity for using <a href="http://docs.php.net/pdo.prepared-statements" rel="nofollow noreferrer">prepared statements</a>. Also take a look at the tips at <a href="http://dev.mysql.com/doc/refman/5.0/en/insert-speed.html" rel="nofollow noreferrer">http://dev.mysql.com/doc/refman/5.0/en/insert-speed.html</a>, e.g. <blockquote>To speed up INSERT operations that are performed with multiple statements for nontransactional tables, lock your tables</blockquote> You can also decrease the number of queries. E.g. you can eliminate the <code>SELECT...FROM persons_table</code> to obtain the id by using <code>INSERT...ON DUPLICATE KEY UPDATE</code> and <a href="http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_last-insert-id" rel="nofollow noreferrer">LAST_INSERT_ID(expr)</a>. ( sorry, running out of time for a lengthy description, but I wrote an example before noticing the time ;-) If this answer isn't downvoted too much I can hand it in later. ) <pre><code>class Foo { protected $persons_table='personsTemp'; protected $pdo; protected $stmts = array(); public function __construct($pdo) { $this->pdo = $pdo; $this->stmts['InsertPersons'] = $pdo->prepare(' INSERT INTO '.$this->persons_table.' (person) VALUES (:person) ON DUPLICATE KEY UPDATE id=LAST_INSERT_ID(id) '); } public function getActorId($name) { $this->stmts['InsertPersons']->execute(array(':person'=>$name)); return $this->pdo->lastInsertId('id'); } } $pdo = new PDO("mysql:host=localhost;dbname=test", 'localonly', 'localonly'); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // create a temporary/test table $pdo->exec('CREATE TEMPORARY TABLE personsTemp (id int auto_increment, person varchar(32), primary key(id), unique key idxPerson(person))'); // and fill in some data foreach(range('A', 'D') as $p) { $pdo->exec("INSERT INTO personsTemp (person) VALUES ('Person $p')"); } $foo = new Foo($pdo); foreach( array('Person A', 'Person C', 'Person Z', 'Person B', 'Person Y', 'Person A', 'Person Z', 'Person A') as $name) { echo $name, ' -> ', $foo->getActorId($name), "\n"; } </code></pre> prints <pre><code>Person A -> 1 Person C -> 3 Person Z -> 5 Person B -> 2 Person Y -> 6 Person A -> 1 Person Z -> 5 Person A -> 1 </code></pre> (someone might want to start a discussion whether a getXYZ() function should perform an INSERT or not ...but not me, not now....)
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POCombine many MySQL queries with logic into data file
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USVolkerK
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POCombine many MySQL queries with logic into data file
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
CommentsPostId
1. COThis looks promising for the reference tables and should save me thousands of query by the end of the job. Thanks!
 singulars
 PostPostId
 PO
 UserUserId
 USEddie
2. CONice I have boosted my count to 100 titles per second by leverageing this for genres, formats and actors. DO you know that tthe performance of the insert into v a select is?
 singulars
 PostPostId
 PO
 UserUserId
 USEddie

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.