Codetown
Codetown ::: a software developer's community
screencast about MySQL for Developers
If you are a developer using MySQL, you should learn enough to take advantage of its strengths, because having an understanding of the database can help you develop better-performing applications. This session will talk about MySQL database design and SQL tuning for developers. Some topics include:
* MySQL Storage Engine Architecture
* Schema, the basic foundation of performance
* Think about performance when choosing Data Types
* Indexes and SQL tuning
* Understanding SQL Statements using EXPLAIN
* Scans and seeks
* Solving performance problems in your queries
* A Few Things to consider for JPA/Hibernate devlopers, Lazy loading and Optimistic locking
http://mediacast.sun.com/users/caroljmcdonald/media/mysqlproj.swf
You can download the slides here
https://techdayscode.dev.java.net/servlets/ProjectDocumentList?fold...
You can read more about this at
MySQL for Developers
GlassFish and MySQL, Part 4: Creating a RESTful Web Service and JavaFX Client
High Performance MySQL book
MySQL Pluggable Storage Engine Architecture
MySQL Storage Engine Architecture, Part 2: An In-Depth Look
Optimizing Queries with EXPLAIN
Java Persistence with Hibernate book
Jay Pipes blog
Colin Charles blog
mysql performance blog
Ronald Bradford blog
Taking JPA for a Test Drive
Pro EJB 3: Java Persistence API
Pro MySQL, Chapter 6: Benchmarking and Profiling
Comment
Happy 10th year, JCertif!
Notes
Welcome to Codetown!
Codetown is a social network. It's got blogs, forums, groups, personal pages and more! You might think of Codetown as a funky camper van with lots of compartments for your stuff and a great multimedia system, too! Best of all, Codetown has room for all of your friends.
Created by Michael Levin Dec 18, 2008 at 6:56pm. Last updated by Michael Levin May 4, 2018.
Looking for Jobs or Staff?
Check out the Codetown Jobs group.
InfoQ Reading List
Presentation: Production Comes First - An Outside-In Approach to Building Microservices
Martin Thwaites introduces outside-in testing, how to use Observability techniques in a local development to build applications that are easier to debug locally and run as a first class citizen.
By Martin ThwaitesPhysical Intelligence Unveils Robotics Foundation Model Pi-Zero
Physical Intelligence recently announced π0 (pi-zero), a general-purpose AI foundation model for robots. Pi-zero is based on a pre-trained vision-language model (VLM) and outperforms other baseline models in evaluations on five robot tasks.
By Anthony AlfordAWS Launches Lambda SnapStart for Python and .NET Functions
AWS has unveiled Lambda SnapStart for Python and .NET, enhancing serverless app performance by reducing cold start latency. This feature builds on the success of Lambda SnapStart for Java, allowing faster initializations through early environment caching. Available in multiple global regions, it offers efficient management of caching costs with Python 3.12+ and .NET 8+.
By Steef-Jan WiggersAWS Reveals Multi-Agent Orchestrator Framework for Managing AI Agents
AWS has introduced Multi-Agent Orchestrator, a framework designed to manage multiple AI agents and handle complex conversational scenarios. The system routes queries to the most suitable agent, maintains context across interactions, and integrates seamlessly with a variety of deployment environments, including AWS Lambda, local setups, and other cloud platforms.
By Daniel DominguezJava News Roundup: Last of the JEPs Targeted to JDK 24, Quarkus 3.17, Maven 4.0-RC1, Kotlin 2.1
This week's Java roundup for November 25th, 2024 features news highlighting: the last of the JEPs targeted to JDK 24 before Rampdown Phase One; the release of Quarkus 3.17.0, Hibernate Search 7.2.2, Kotlin 2.1.0 and JDKUpdater 14.0.67+100; the second release candidate of Vert.x 5.0 and the first release candidate of Maven 4.0.0.
By Michael Redlich
© 2024 Created by Michael Levin.
Powered by
You need to be a member of Codetown to add comments!
Join Codetown