| complex website database [message #3385] |
Fri, 08 August 2008 05:07  |
 mumuri
Messages: 3
Registered: August 2008 |
Junior Member |
|
|
Hello, i m new to this forum
I ve got a little question about a database structure
for two given website, i have one database
database
table:articles_site1
table:articles_site2
table:users
when i m logged in the first website, the article are taken from article_site1
when i m logged in the second website, the article are taken from article_site2
when i m logged in the second website, i m logged in the first website (vice versa)
---------------------------------
now i would like to do a view of an union of articles_site1 and articles_site2, in order to display information (like similar discusions for an article) taken from the union of the two tables
what is the best chose temporarytable or merge, i think it s temporarytable but i m not sure, my other problem is that fulltext is not supported on view,
i looked at this article, but didn't manage to find the answer
http://www.mysqlperformanceblog.com/2007/08/12/mysql-view-as -performance-troublemaker/
i was thinking to merge this two articles_siteX table in one, and to update them via a cron at night, will this give me bette performance ?
thanks in advance
[Updated on: Fri, 08 August 2008 06:11]
|
|
|
|
|
| Re: complex website database [message #3394 is a reply to message #3385 ] |
Sat, 09 August 2008 13:25  |
|
Why not just do
SELECT * FROM articles_site1
UNION
SELECT * FROM articles_site2
Then you can take advantage of the fulltext indexes on each table and sort the final results.
|
|
|
|
Members
Search
Help
Register
Login
Home
