Tagged Questions
2
votes
2answers
360 views
Why OTServs have an item cloning problem if the server crashes? [closed]
OTServs are open source MMORPGs with a huge community. Mostly all of them have a serious problem: if the server crashes, people can clone items. This is a dirty trick that can be executed because the ...
3
votes
7answers
3k views
Best practices to follow with database indexes [closed]
What are some DOs and DONTs for improving database performance using index?
A DO would be a case in which an index should be created, or another indexes related tip that will improve performance.
A ...
5
votes
1answer
600 views
Search multiple tables
I have developed a web application that is used mainly for archiving all sorts of textual material (documents, references to articles, books, magazines etc.). There can be any given number of archive ...
4
votes
3answers
338 views
How should I implement Transaction database EJB 3.0
In the CustomerTransactions entity, I have the following field to record what the customer bought:
@ManyToMany
private List<Item> listOfItemsBought;
When I think more about this field, ...
2
votes
1answer
1k 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?
5
votes
5answers
394 views
Should I use a relational datamodel or Cassandra with ColumnFamily based indexes?
Currently we are working on some storage problems for log data from various servers and communication message logs (HTTP(S), XMPP). There will be many write operations and for read operations we will ...
2
votes
3answers
216 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 ...
38
votes
12answers
9k views
Is it a bad practice to store large files (10 MB) in a database? [closed]
I am currently creating a web application that allows users to store and share files, 1 MB - 10 MB in size.
It seems to me that storing the files in a database will significantly slow down ...
5
votes
2answers
376 views
How to separate sensitive data in database(MySql)
I need to design a database that will contains information about personal disease of users.
What can be the approach in order to implement the columns of the DB's tables: encrypt the information, ...
-2
votes
1answer
158 views
Adding a forum to an existing site
I've got a site with ~500 registered members, 300 of which are what you'd call "active". Site data is kept in a MySQL dbase.
I'd like to add a myBB forum to the site, but this question applies to any ...
1
vote
4answers
340 views
What are some good tips for a developer trying to design a scalable MySQL database?
As the question states, I am a developer, not a DBA. I have experience with designing good ER schemas and am fairly knowledgeable about normalization and good schema design. I have also worked with ...
4
votes
9answers
4k views
Is there a large bank using Mysql or PostgreSQL? [closed]
I always thought the largest scale of banks use Oracle. However, there is no proof they really use Oracle instead of Mysql or PostgreSQL, nobody knows the secret.
Any idea what they really use? Can ...
1
vote
2answers
107 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
181 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. ...
1
vote
2answers
296 views
Database design
I'm on the way developing an application which requires a kind of dynamic database,
So this is what I want,
This is the for reading the details of a class, the number of variables and methods ...
