FUDforum: comp.lang.php » Most efficient way to randomize a quiz from a database

Home » Imported messages » comp.lang.php » Most efficient way to randomize a quiz from a database

Show: Today's Messages :: Polls :: Message Navigator

Most efficient way to randomize a quiz from a database [message #170563]

Mon, 08 November 2010 16:08

Mason Barge
Messages: 5
Registered: November 2010

Karma:

Junior Member

I'm creating a quiz using PHP 5.3 and MySQL (mysqli). The database has
about 1000 questions and answers, in categories, and I want to ask 12
randomly selected questions, one at a time.

Which would be more efficient:

1) Make one call to the database and build an array, stored in session
variables, of 12 randomly chosen rows; or

2) Make 12 requests to the database?

I'm open to other general approaches if anyone has a suggestion I haven't
considered.

I'd like to avoid reloading the page after every answer and I don't see
how I could use Ajax with #1. The quiz has to be in PHP because I need to
generate the final score as a PHP variable, not a javascript variable.

Report message to a moderator

[Message index]

		Most efficient way to randomize a quiz from a database By: Mason Barge on Mon, 08 November 2010 16:08
		Re: Most efficient way to randomize a quiz from a database By: Captain Paralytic on Mon, 08 November 2010 16:26
		Re: Most efficient way to randomize a quiz from a database By: Matthew Leonhardt on Mon, 08 November 2010 16:45
		Re: Most efficient way to randomize a quiz from a database By: Mason Barge on Mon, 08 November 2010 18:52
		Re: Most efficient way to randomize a quiz from a database By: Erwin Moller on Tue, 09 November 2010 09:48
		Re: Most efficient way to randomize a quiz from a database By: Matthew Leonhardt on Tue, 09 November 2010 14:55
		Re: Most efficient way to randomize a quiz from a database By: Erwin Moller on Tue, 09 November 2010 16:09
		Re: Most efficient way to randomize a quiz from a database By: Matthew Leonhardt on Tue, 09 November 2010 18:46

Previous Topic:	how to retrieve xml data from three tables of mysql
Next Topic:	Cronjob Apache module v CGI

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 14:44:10 GMT 2024

Total time taken to generate the page: 0.03747 seconds