Tagged Questions
2
votes
1answer
70 views
Bayes filtering and data storage with expansive data sets
I am looking to write a Bayes filter that will act as an indicator of topic for a number of topics with a variable number of sources. Given a really big number of RSS feeds and here really big might ...
2
votes
3answers
207 views
Application Logic Vs DB Triggers for database cleaning
When cleaning out old data from a set of database tables, is it safer to have the logic in the application or in a database trigger?
I am upgrading an application that I wrote a while back (and in a ...
2
votes
2answers
920 views
Booking system (Handle working hours, Get available time slots) [closed]
I'm currently working on a time booking system for a friends hair salon. The plan is to try to keep it as simple as possible.
The user view (where the owner see the booked appointments) is more or ...
1
vote
2answers
106 views
In which format should I sent the values in database in PHP?
I am developing an application which is based on the quiz contest for competetive exams. The user can give different categories of tests, which will contain different types of questions of following ...
1
vote
1answer
177 views
Is using dynamically generated code as cache a good idea?
I have a web search interface that can compare products in a table. This data set changes a few times a week.
I have been storing a "DISTINCT" list (used for parametric selection) in a cache table. ...
3
votes
1answer
221 views
What are the advantages and disadvantages of storing the number of comments in an integer column vs. calculating it on the fly?
Let's take CodeReview page as an example. If you go here, you will see the list of the questions with their vote numbers and comment numbers
Now, I am wondering if these numbers are calculated on the ...
1
vote
1answer
132 views
What's the best way to design a data and php model for a multi-account system?
I'm doing some high-level sketching of a system that will require users to register, when they do they get an account and can invite others to that account.
To be clear, an account would be similar ...
5
votes
2answers
316 views
How can I design an efficient moderation system for comments?
Here's the job I want to do:
My project is a website where there will be a lot of comments.
Those comments will be moderated: a moderator will connect, see comments and accept or refuse them.
I need ...
2
votes
1answer
981 views
How does Facebook calculate mutual friends?
How does Facebook calculate mutual friends?
Does it cache all mutual friends for each user? Does it use MySQL to calculate mutual friends with a query?
2
votes
6answers
174 views
Is 2 hours enough to confirm account or delete it
What if someone tries to register with an email that's not theirs. When they register, they get emailed a verification code to complete registration. If that's not their email, they don't get it, so ...
