StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POBDB, How to get primary keys in specified order?
text
Body
copied!<p>I have asked the same question for some days on oracle forums, but no answer came:( link is:http://forums.oracle.com/forums/thread.jspa?threadID=2162345&tstart=0</p> <p>Hi, I build BBS using BDB as backend database, forum database, topic database and post database share one environment. This BBS web application is multi-thread program. If user selects one forum, its topics will be listed in order of last reply time;selecting one topic, posts are listed in order of reply time as well.</p> <pre><code>struct forum { UInt16 forumID; string forumName; string _lastPoster; // who is the last one replied in this forum }; struct topic { UInt32 topicID; UInt16 forumID; // topic comes from this forum string title; // topic title UInt64 dateOfLastReply; // when last reply to this topic happen }; struct post { UInt64 postID; UInt32 topicID; // post comes from this topic string title; // post title as of topic UInt64 dateOfPost; // when this post is created }; </code></pre> <p>I create one primary database and two secondary databases for topic, primary key is topicID, secondary keys are forumID and dateOfLastReply respectively, and I want to show 1st 25 topics in latest reply time order on the 1st browser page, 2nd 25 topics on the 2nd browser page, and etc.</p> <p>if using SQL, it will be: <strong>SELECT</strong> topicID <strong>FROM</strong> topic <strong>WHERE</strong> forumID=xx <strong>ORDER BY</strong> dateOfLastReply <strong>DESC</strong></p> <p>From performance perspective, I want get all topics id of one same forum, and need them come in reply time order, then retrieve topic one by one based on returned topicID, how can I do this? guess I have to use joins. Plus, do you have any suggestion about retrieval performance given the fact that topics retrieval will happen each time browser want to request the next page, that is, 2nd 25 topics of this forum? Is DB_DBT_MULTIPLE helpful to me?</p> <p>thanks.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload