Game Development Stack Exchange is a question and answer site for professional and independent game developers. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm planning to develop a game in which I want to draw 3d models in real time using some given x,y,z coordinates. The coordinates will be given at an average of 30 coordinates per second. Drawing will happen maximum of 15 seconds (450 coordinate sets)

For faster retrieval what, is the most efficient way of retrieving data? Is it storing in file system (storing coordinates in a text file etc.) or storing the coordinates in a database (SQL).

share|improve this question
Everything depends on what the source stream for these coordinates is and why do they need persisting, if at all. – Patrick Hughes Feb 11 '12 at 19:14
up vote 4 down vote accepted

For real-time retrieval you wouldn't use a text file or a database - you'd have the data in memory. It's not clear why you would want to persist these details to the disk if you're just rendering them on-screen.

share|improve this answer

No matter where do these coordinates come from (database or filesystem), before drawing them, you should load them into memory and cache them for drawing. Is your memory big enough to contain all coordinates? I guess it shouldn't be a problem.

share|improve this answer
If memory isn't big enough to contain all the coordinates he's got bigger problems to solve for "real-time" than mere file access =) – Patrick Hughes Feb 11 '12 at 20:58

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.