我正在用php制作一个webservice,我的网站将用ajax调用来查询信息。
一开始,我只是用内置的php mysql库以标准的方式完成了这项工作,然后手工编写了所有的查询,并在mysql工作台中创建了整个数据模型等等。这是非常耗时的,如果我不得不在之后更改数据模型,一切都会变得非常复杂,所以我决定寻找一个php orm,我发现redbean在我看来是纯粹的魔法和乐趣。
但我在表演上很纠结。我的网站是一个用户创建自己的电视剧列表的网站。我查询一个serie的外部源并将它插入到我的数据库中(如果它还不在那里),否则我将从自己的ofc数据库中获取它。
我从这个外部源得到的XML列出了系列、季节、剧集等等,我都是这样存储的。
function InsertSerie($serie) {
$serieBean = $this->CreateSerieBean($serie->Series);
$genreBeans = $this->CreateGenreBeans($serie->Series->Genre);
$actorBeans = $this->CreateActorBeans($serie->Series->Actors);
$episodeBeans = array();
foreach ($serie->Episode as $episode) {
$episodeBean = $this->CreateEpisodeBean($episode);
$seasonBean = $this->CreateSeasonBean($episode);
$writerBeans = $this->CreateWriterBeans($episode->Writer);
$guestBeans = $this->CreateActorBeans($episode->GuestStars);
$directorBeans = $this->CreateDirectorBeans($episode->Director);
R::associate($episodeBean, $seasonBean);
foreach ($writerBeans as $bean) {
R::associate($episodeBean, $bean);
}
foreach ($guestBeans as $bean) {
R::associate($episodeBean, $bean);
}
foreach ($directorBeans as $bean) {
R::associate($episodeBean, $bean);
}
$episodeBeans[] = $episodeBean;
}
foreach ($genreBeans as $bean) {
R::associate($serieBean, $bean);
}
foreach ($actorBeans as $bean) {
R::associate($serieBean, $bean);
}
foreach ($episodeBeans as $bean) {
R::associate($serieBean, $bean);
}
}
function CreateGenreBeans($genres) {
if(empty($genres)) { return; }
$genre = explode("|", $genres);
$genreBeans = array();
foreach ($genre as $g) {
if($g != '') {
$genreBeans[] = $this->CreateGenreBean($g);
}
}
return $genreBeans;
}
function CreateGenreBean($genre) {
$bean = R::dispense('genre');
$bean->name = (string)$genre;
return $bean;
}
function CreateDirectorBeans($directors) {
if(empty($directors)) { return; }
$director = explode("|", $directors);
$directorBeans = array();
foreach ($director as $d) {
if($d != '') {
$directorBeans[] = $this->CreateDirectorBean($d);
}
}
return $directorBeans;
}
function CreateDirectorBean($director) {
$bean = R::dispense('director');
$bean->name = (string)$director;
return $bean;
}
function CreateActorBeans($actors) {
if(empty($actors)) { return; }
$actor = explode("|", $actors);
$actorBeans = array();
foreach ($actor as $a) {
if($a != '') {
$actorBeans[] = $this->CreateActorBean($a);
}
}
return $actorBeans;
}
function CreateActorBean($actor) {
$bean = R::dispense('actor');
$bean->name = (string)$actor;
return $bean;
}
function CreateWriterBeans($writers) {
if(empty($writers)) { return; }
$writer = explode("|", $writers);
$writerBeans = array();
foreach ($writer as $w) {
if($w != '') {
$writerBeans[] = $this->CreateWriterBean($w);
}
}
return $writerBeans;
}
function CreateWriterBean($writer) {
$bean = R::dispense('writer');
$bean->name = (string)$writer;
return $bean;
}
function CreateSerieBean($serie) {
$bean = R::dispense('serie');
$bean->serie_id = (string)$serie->id;
$bean->airs_day_of_week = (string)$serie->Airs_DayOfWeek;
$bean->airs_time = (string)$serie->Airs_Time;
$bean->content_rating = (string)$serie->ContentRating;
$bean->first_aired = (string)$serie->FirstAired;
$bean->imdb_id = (string)$serie->IMDB_ID;
$bean->language = (string)$serie->Language;
$bean->network = (string)$serie->Network;
$bean->overview = (string)$serie->Overview;
$bean->rating = (string)$serie->Rating;
$bean->rating_count = (string)$serie->RatingCount;
$bean->run_time = (string)$serie->Runtime;
$bean->serie_name = (string)$serie->SeriesName;
$bean->status = (string)$serie->Status;
$bean->last_updated = (string)$serie->lastupdated;
$bean->thumbnail = (string)$serie->thumbnail;
return $bean;
}
function CreateSeasonBean($episode) {
$bean = R::dispense('season');
$bean->season_id = (string)$episode->seasonid;
$bean->season_number = (string)$episode->SeasonNumber;
return $bean;
}
function CreateEpisodeBean($episode) {
$bean = R::dispense('episode');
$bean->episode_id = (string)$episode->id;
$bean->episode_name = (string)$episode->EpisodeName;
$bean->episode_number = (string)$episode->EpisodeNumber;
$bean->first_aired = (string)$episode->FirstAired;
$bean->imdb_id = (string)$episode->IMDB_ID;
$bean->language = (string)$episode->Language;
$bean->overview = (string)$episode->Overview;
$bean->rating = (string)$episode->Rating;
$bean->rating_count = (string)$episode->RatingCount;
$bean->last_updated = (string)$episode->lastupdated;
return $bean;
}
问题是,插入一个serie大约需要5分钟,同时插入重复的serie,执行
R::freeze();
也无助于性能。问:我怎样才能解决这个问题,怎样才能让redbean更好地运行,怎样才能让自己的代码更好地工作,或者我应该简单地使用一个不同的解决方案/方法框架等等?
尝试了建议的共享列表,但结果相同。
function InsertSerie($serie) {
$serieBean = $this->CreateSerieBean($serie->Series);
...
foreach ($serie->Episode as $episode) {
$episodeBean = $this->CreateEpisodeBean($serieBean ,$episode);
...
$this->CreateDirectorBeans($serieBean, $episode->Director);
$serieBean->sharedEpisode[] = $episodeBean;
}
R::store($serieBean);
}
function CreateDirectorBeans($bean, $directors) {
if(empty($directors)) { return; }
$director = explode("|", $directors);
foreach ($director as $d) {
if($d != '') {
$bean->sharedDirector[] = $this->CreateDirectorBean($d);
}
}
}
function CreateDirectorBean($director) {
$bean = R::dispense('director');
$bean->name = (string)$director;
return $bean;
}
....
最佳答案
我终于找到了如何将执行时间从5分钟降低到11秒,仍然需要分配时间,但考虑到数据量和它必须做的工作,我认为这对硬件有好处。
我添加了这些代码行
R::Begin();
R::associate($bean1, $bean2);
...
R::commit();
现在它收集所有的工作并在一个大事务中执行,比如工作单元模式。同时为了防止插入重复的内容,我使用
$bean = R::findOrDispense($type, $sql, $values);
然后,如果bean已经存在,我就返回它,如果不存在,我就创建一个新的bean并返回它。