Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2009
    Posts
    1

    Unhappy Unanswered: BBS notice problem.

    I'm writing a forum web application, and have a critical problem:
    The application have a feature that need support notice for all registered user, and must mark the read or unread, and have a great many of notice.
    Because the notice number is larger, so I design a table for store the notice (system_notice), it have 3 fields (id/issue_date/content), and design a table for store read flag (notice_read_flags), it have 3 fields (id/user_id/system_notice_id).
    The application can run, but when user number more than 10000, and the system notice number more than 300, the query is slow.


    Who can help me resolve it or have another solution, thanks in advanced!

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >the query is slow.
    If you say so.

    You have Operating System name & version. We don't.
    You have Oracle version to 4 decimal places. We don't.
    You have table & DDL for table. We don't.
    You have data & DML for data. We don't.
    You know what indexes on which columns. We don't.
    You have SQL statement which runs slow. We don't.

    So please explain by what voodoo, magic, or crystal ball reading do you actually expect a helpful response to this mystery?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •