3
\$\begingroup\$

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).

Improve this question
\$\endgroup\$
1
  • \$\begingroup\$ Everything depends on what the source stream for these coordinates is and why do they need persisting, if at all. \$\endgroup\$
    – Patrick Hughes
    Feb 11, 2012 at 19:14

2 Answers 2

Reset to default
4
\$\begingroup\$

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.

Improve this answer
\$\endgroup\$
2
\$\begingroup\$

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.

Improve this answer
\$\endgroup\$
1
  • 1
    \$\begingroup\$ 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 =) \$\endgroup\$
    – Patrick Hughes
    Feb 11, 2012 at 20:58

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .