Brisbane WebTech 28 May 6:30pm asynchronous/paralle­l database queries

Those using Javascript are already used to asynchronous http requests. But there is an additional way to optimise your application on the server side. It's not actually new, but as I rarely see it used I think it's worth a meetup session!

Several MySQL and MariaDB client libraries support asynchronous queries. That is, you could send a SELECT query and not wait for the result but instead pick it up later. If you were to open multiple database connections (even to different servers) this would allow you to truly run queries in parallel, but at the very least you could do some other tasks in PHP while the query is getting processed.

Similarly, a write query could be sent off and you just need to make sure it gets done before the script ends, but no need to have the user wait right now... process other stuff while waiting.

These are just a few examples. It means using different application logic (since generally your server-side script language is not multi-threaded), but it can be done.

For PHP, the php/mysqli extension can be used. You will also need to learn a few more things about MySQL/MariaDB configuration.

At this meetup, we'll look at how it works, and discuss how to best use this feature!

Please arrive before 6:30pm so that we can start on time.

Tell your dev friends, rsvp, and see you all there!

Join or login to comment.

  • Arjen L.

    very useful - good ideas and discussion.

    May 29, 2013

12 went

Our Sponsors

People in this
Meetup are also in:

Create a Meetup Group and meet new people

Get started Learn more
Allison

Meetup has allowed me to meet people I wouldn't have met naturally - they're totally different than me.

Allison, started Women's Adventure Travel

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy