veyepar: Speed Up Your Database

Hi user

Admin Login:

Name: Speed Up Your Database
--client pyconca --show pyconca2012 --room Lower_hall 1523 --force
Prev: 11 Programmatically Managing Python Workloads Across Multiple Clouds
Next: 11 Gevent-socketio, cross-framework real-time web live demo

show more...

Author(s):	Anna Filina
Location	Lower hall
Date	nov Sun 11	Days Raw Files
Start	15:15	First Raw Start	15:10
Duration	00:20:00	Offset	0:04:23
End	15:35	Last Raw End	15:45
Chapters	00:00 0:15:53
Total cuts_time	17 min.

http://pycon.ca/talk/26
raw-playlist raw-mp4-playlist encoded-files-playlist host archive public mp4 svg png

final audio

assets release.pdf Speed_Up_Your_Database.json
logs
Admin: episode episode list cut list raw files day marks day marks day image_files

State:
Locked:	clear this to unlock
Locked by:	user/process that locked.
Start:	initially scheduled time from master, adjusted to match reality
Duration:	length in hh:mm:ss
Name:	Video Title (shows in video search results)
Emails:	email(s) of the presenter(s)
Released:	has someone authorised pubication
Normalise:
Channelcopy:	m=mono, 01=copy left to right, 10=right to left, 00=ignore.
Thumbnail:	filename.png
Description:	Are your queries slow? Learn how to speed them up through better SQL crafting and use meaningful indices. Attendees will understand what works well and what doesn't, and will walk away with a checklist for faster databases. markdown
Comment:	<?xml version='1.0' encoding='UTF-8'?> <ns0:entry xmlns:ns0="http://www.w3.org/2005/Atom"><ns0:category scheme="http://schemas.google.com/g/2005#kind" term="http://gdata.youtube.com/schemas/2007#video" /><ns0:category label="Education" scheme="http://gdata.youtube.com/schemas/2007/categories.cat" term="Education" /><ns0:category scheme="http://gdata.youtube.com/schemas/2007/keywords.cat" term="pyconca" /><ns0:category scheme="http://gdata.youtube.com/schemas/2007/keywords.cat" term="pyconca2012" /><ns0:category scheme="http://gdata.youtube.com/schemas/2007/keywords.cat" term="AnnaFilina" /><ns0:id>http://gdata.youtube.com/feeds/api/videos/5fPIyN-bmOA</ns0:id><ns0:author><ns0:name>NextDayVideo</ns0:name><ns0:uri>https://gdata.youtube.com/feeds/api/users/NextDayVideo</ns0:uri></ns0:author><ns0:content type="text">Anna Filina Are your queries slow? Learn how to speed them up through better SQL crafting and use meaningful indices. Attendees will understand what works well and what doesn't, and will walk away with a checklist for faster databases.</ns0:content><ns0:updated>2012-11-13T20:55:33.000Z</ns0:updated><ns0:published>2012-11-13T20:55:33.000Z</ns0:published><ns1:comments xmlns:ns1="http://schemas.google.com/g/2005"><ns1:feedLink countHint="0" href="https://gdata.youtube.com/feeds/api/videos/5fPIyN-bmOA/comments?client=NextDayVideo" rel="http://gdata.youtube.com/schemas/2007#comments" /></ns1:comments><ns1:group xmlns:ns1="http://search.yahoo.com/mrss/"><ns1:keywords>pyconca, pyconca2012, AnnaFilina</ns1:keywords><ns1:description type="plain">Anna Filina Are your queries slow? Learn how to speed them up through better SQL crafting and use meaningful indices. Attendees will understand what works well and what doesn't, and will walk away with a checklist for faster databases.</ns1:description><ns1:title type="plain">Speed Up Your Database</ns1:title><ns2:duration seconds="0" xmlns:ns2="http://gdata.youtube.com/schemas/2007" /><ns1:content duration="0" expression="full" isDefault="true" medium="video" type="application/x-shockwave-flash" url="https://www.youtube.com/v/5fPIyN-bmOA?version=3&f=user_uploads&c=NextDayVideo&d=Aarb2r5skm2_yNTuKEinXdAO88HsQjpE1a8d1GxQnGDm&app=youtube_gdata" ns2:format="5" xmlns:ns2="http://gdata.youtube.com/schemas/2007" /><ns1:thumbnail height="360" time="00:00:00" url="http://i.ytimg.com/vi/5fPIyN-bmOA/0.jpg" width="480" /><ns1:thumbnail height="90" time="00:00:00" url="http://i.ytimg.com/vi/5fPIyN-bmOA/1.jpg" width="120" /><ns1:thumbnail height="90" time="00:00:00" url="http://i.ytimg.com/vi/5fPIyN-bmOA/2.jpg" width="120" /><ns1:thumbnail height="90" time="00:00:00" url="http://i.ytimg.com/vi/5fPIyN-bmOA/3.jpg" width="120" /><ns1:category label="Education" scheme="http://gdata.youtube.com/schemas/2007/categories.cat">Education</ns1:category><ns1:category scheme="http://gdata.youtube.com/schemas/2007/developertags.cat">pyconca</ns1:category><ns1:category scheme="http://gdata.youtube.com/schemas/2007/developertags.cat">pyconca2012</ns1:category><ns1:category scheme="http://gdata.youtube.com/schemas/2007/developertags.cat">AnnaFilina</ns1:category><ns1:player url="https://www.youtube.com/watch?v=5fPIyN-bmOA&feature=youtube_gdata_player" /></ns1:group><ns0:title type="text">Speed Up Your Database</ns0:title><ns1:control xmlns:ns1="http://purl.org/atom/app#"><ns1:draft>yes</ns1:draft><ns2:state name="processing" xmlns:ns2="http://gdata.youtube.com/schemas/2007" /></ns1:control><ns0:link href="https://www.youtube.com/watch?v=5fPIyN-bmOA&feature=youtube_gdata" rel="alternate" type="text/html" /><ns0:link href="https://gdata.youtube.com/feeds/api/videos/5fPIyN-bmOA/responses?client=NextDayVideo" rel="http://gdata.youtube.com/schemas/2007#video.responses" type="application/atom+xml" /><ns0:link href="https://gdata.youtube.com/feeds/api/videos/5fPIyN-bmOA/ratings?client=NextDayVideo" rel="http://gdata.youtube.com/schemas/2007#video.ratings" type="application/atom+xml" /><ns0:link href="https://gdata.youtube.com/feeds/api/videos/5fPIyN-bmOA/complaints?client=NextDayVideo" rel="http://gdata.youtube.com/schemas/2007#video.complaints" type="application/atom+xml" /><ns0:link href="https://gdata.youtube.com/feeds/api/videos/5fPIyN-bmOA/related?client=NextDayVideo" rel="http://gdata.youtube.com/schemas/2007#video.related" type="application/atom+xml" /><ns0:link href="https://gdata.youtube.com/feeds/api/users/nextdayvideo/uploads/5fPIyN-bmOA?client=NextDayVideo" rel="self" type="application/atom+xml" /><ns0:link href="https://gdata.youtube.com/feeds/api/users/nextdayvideo/uploads/5fPIyN-bmOA?client=NextDayVideo" rel="edit" type="application/atom+xml" /></ns0:entry> production notes

2012-11-11/15_10_37.dv Apply: 15:10:37 - 15:15:39 ( 00:05:02 ) S: 15:10:37 - E: 15:15:39 D: 00:05:02 show more...

vlc ~/Videos/veyepar/pyconca/pyconca2012/dv/Lower_hall/2012-11-11/15_10_37.dv :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	15:10:37		seconds: 0.0 Wall: 15:10:37
Duration	00:05:02
	15:15:39		seconds: 0.0 Wall: 15:10:37
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

audio viz

2012-11-11/15_15_40.dv Apply: 15:15:40 - 15:31:33 ( 00:15:53 ) S: 15:15:40 - E: 15:31:33 D: 00:15:53 show more...

vlc ~/Videos/veyepar/pyconca/pyconca2012/dv/Lower_hall/2012-11-11/15_15_40.dv :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	15:15:40		seconds: 0.0 Wall: 15:15:40
Duration	00:15:53
	15:31:33		seconds: 0.0 Wall: 15:15:40
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

audio viz

2012-11-11/15_31_34.dv Apply: 15:31:34 - 15:32:10 ( 00:00:36 ) S: 15:31:34 - E: 15:32:10 D: 00:00:36 show more...

vlc ~/Videos/veyepar/pyconca/pyconca2012/dv/Lower_hall/2012-11-11/15_31_34.dv :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	15:31:34		seconds: 0.0 Wall: 15:31:34
Duration	00:00:36
	15:32:10		seconds: 0.0 Wall: 15:31:34
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

audio viz

2012-11-11/15_32_10.dv Apply: 15:32:10 - 15:34:09 ( 00:01:59 ) S: 15:32:10 - E: 15:34:09 D: 00:01:59 show more...

vlc ~/Videos/veyepar/pyconca/pyconca2012/dv/Lower_hall/2012-11-11/15_32_10.dv :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	15:32:10		seconds: 0.0 Wall: 15:32:10
Duration	00:01:59
	15:34:09		seconds: 0.0 Wall: 15:32:10
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

audio viz

2012-11-11/15_34_10.dv Apply: 15:34:10 - 15:45:15 ( 00:11:05 ) S: 15:34:10 - E: 15:45:15 D: 00:11:05 show more...

vlc ~/Videos/veyepar/pyconca/pyconca2012/dv/Lower_hall/2012-11-11/15_34_10.dv :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	15:34:10		seconds: 0.0 Wall: 15:34:10
Duration	00:11:05
	15:45:15		seconds: 0.0 Wall: 15:34:10
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

audio viz

Rf filename:	root is .../show/dv/location/, example: 2013-03-13/13:13:30.dv
Sequence:
get this:	check and save to add this

2012-11-11/15_10_37.dv
audio viz

audio viz

2012-11-11/15_15_40.dv
audio viz

audio viz

2012-11-11/15_31_34.dv
audio viz

audio viz

2012-11-11/15_32_10.dv
audio viz

audio viz

2012-11-11/15_34_10.dv
audio viz

audio viz

Veyepar Video Eyeball Processor and Review