You are here:

MySQL/MySQL cursor / Laravel4 queries


Hello, I'm doing a project in school - a website basically for my institution. I'm using Laravel4 PHP framework and MySQL.
A few days ago one of my teachers asked -
"How many cursors are open at the same time at max?"
Now I got a bit puzzled. I used cursor while using Oracle PL/SQL, I'm guessing MySQL also has something like this. But I've only used SQL queries in my project, no PL. Even then as far my knowledge goes to iterate over collection of rows I need cursors, so somehow cursors are handled internally. So now the main question:
How do I find out how many cursors are open simultaneously? Wouldnt it depend on how many people are visiting my site?

Dear Sir

Rather than me type it all out for you to read I have found a link that pretty much covers the topic with some good examples. Read through the following link and see how you do.

I hope this helps you


All Answers

Answers by Expert:

Ask Experts


stuart gregory


PHP html, xhtml, css coding and MySQL


My experiance is all first had as I am web developer and I have, and do build many websites all using php and mysql. This ranges from building a simple search engine to secure php login scripts. Some websites like are complete database driven websites.

I have a large number of websites which I host and maintain, such as.

Web application development. (Open University) BSC Honers Computing and development (Open University)

©2016 All rights reserved.