Thread: BBS notice problem.
02-05-09, 00:07 #1Registered User
- Join Date
- Feb 2009
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!
02-05-09, 00:35 #2Registered User
Provided Answers: 1
- Join Date
- Aug 2003
- Where the Surf Meets the Turf @Del Mar, CA
>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.