English 中文(简体)
信息数据库设计效率
原标题:News Feed Database Design Efficiency

招标 所有人, 我看到了以前提出的类似问题,没有经过确定或测试的答案。

I m 采用PHP/MySQL类似手法设计一个新闻收费系统。 由于本表可能会大增——任何效率低下都会造成严重的瓶颈。

Example Notifications: (Items in bold are linked objects)

<>User_A和USER_BUser_C salbum发表评论。

<>User_A在[其]停车场添加了新的<>Vehicle。

最初,我利用奥比耶1:Type1 和Obj2:Ty2 等超栏实施。

它发挥了作用,但我担心,现在我不敢反对序列化。

因此,例如,我的新数据库就是这样建立的:

News_ID  |  User_ID  |                 News_Desc            |   Timestamp

  2643         904     {User904} and {User890} commented on     SomeTimestamp
                       {User222} s new {Album724}.

1名P-4,1名P-3,1名P-2,1名FS,1名UNV

这是否是向前迈进的聪明(高效/可衡量)途径?

利用常规表述将序列化数据与阵列的其他部分分开是困难的吗?

问题回答

如果用户890删除其评论,情况如何? 我认为,你需要更加原样——可能与行动者(User890)储存行动类型,从而产生关于飞行的实际故事,并带来沉重的ach。 如果你把网站延伸到几个市场/审计,这也将有助于翻译问题。





相关问题
Brute-force/DoS prevention in PHP [closed]

I am trying to write a script to prevent brute-force login attempts in a website I m building. The logic goes something like this: User sends login information. Check if username and password is ...

please can anyone check this while loop and if condition

<?php $con=mysql_connect("localhost","mts","mts"); if(!con) { die( unable to connect . mysql_error()); } mysql_select_db("mts",$con); /* date_default_timezone_set ("Asia/Calcutta"); $date = ...

定值美元

如何确认来自正确来源的数字。

Generating a drop down list of timezones with PHP

Most sites need some way to show the dates on the site in the users preferred timezone. Below are two lists that I found and then one method using the built in PHP DateTime class in PHP 5. I need ...

Text as watermarking in PHP

I want to create text as a watermark for an image. the water mark should have the following properties front: Impact color: white opacity: 31% Font style: regular, bold Bevel and Emboss size: 30 ...

How does php cast boolean variables?

How does php cast boolean variables? I was trying to save a boolean value to an array: $result["Users"]["is_login"] = true; but when I use debug the is_login value is blank. and when I do ...

热门标签