We have developed a site where users can post blogs.
Now, each blog is stored in a separate row, in a table called
blog_table.
This single table would be the most active one and would grow to large
size in the coming years.
What is the most advisable engine for this table - Innodb or MyISAM ?
Also, I do need FULLTEXT search, and since Innodb doesn't support
FULLTEXT indexes, are there 3rd party tools that could do the indexing
? (Maybe mnoGoSearch ?)
Mike 3 2700
"siliconmike" <si*********@yahoo.com> wrote in
news:11**********************@g14g2000cwa.googlegr oups.com: We have developed a site where users can post blogs.
Now, each blog is stored in a separate row, in a table called blog_table.
This single table would be the most active one and would grow to large size in the coming years.
interesting.
you don't think there should be one table called "blog_table" with the
name of each blog ("Jenny's Cool BlogWorld") and then a seperate table
called "blog_entries" that has the actual blog entry and a reference to
which blog it should appear in (an ID from "blog_table")? I *guarantee*
this is the proper way to do this, rather than keeping everything in one
single table. For example, what if Jenny wanted to change the title of
her Blog to "Jenny's Terrible BlogWorld"? Or if Jenny wanted to change
her email address/age/sex/anything? Or if she wanted to delete a single
blog entry?
So, we're looking at three tables at minimum:
"blog_owners":
OwnerID | OwnerName | OwnerEmail
1 Sammy P. sa***@me.net
2 Jenny S. je***@example.com
4 Marvin H. ma****@home.net
"blog_table":
BlogID | BlogOwner | BlogTitle
1 2 "Jenny's Cool BlogWorld"
2 4 "Marvin's Blog o Plenty"
"blog_entries":
EntryID | BlogID | BlogEntry
1 2 "My name is Marvin. I am 11 years old."
2 1 "If my name wasn't Jenny, things would be easy"
3 1 "Today mom said, 'Jenny you are great!'"
Therefore, the table seeing the most action/size increase would be
"blog_entries".
What is the most advisable engine for this table - Innodb or MyISAM?
i can't see why you'd even consider InnoDB for this project. what makes
you think you need transactions for this project?
Also, I do need FULLTEXT search, and since Innodb doesn't support FULLTEXT indexes, are there 3rd party tools that could do the indexing
well you've answered your own question here, dont you think. forget
third-party tools. again, there is no reason from what you've given as
to why InnoDB should even be considered.
Instead of leaping in with "what engine should I choose", you should make
sure your database schema is as good as it can be. I would say that the
amount of customizable web projects that run smoothly off of a single
table in a database would be close to zero.
Good Man wrote: "siliconmike" <si*********@yahoo.com> wrote in news:11**********************@g14g2000cwa.googlegr oups.com:
We have developed a site where users can post blogs.
Now, each blog is stored in a separate row, in a table called blog_table.
This single table would be the most active one and would grow to large size in the coming years. interesting.
you don't think there should be one table called "blog_table" with the name of each blog ("Jenny's Cool BlogWorld") and then a seperate table called "blog_entries" that has the actual blog entry and a reference to which blog it should appear in (an ID from "blog_table")? I *guarantee* this is the proper way to do this, rather than keeping everything in one single table. For example, what if Jenny wanted to change the title of her Blog to "Jenny's Terrible BlogWorld"? Or if Jenny wanted to change her email address/age/sex/anything? Or if she wanted to delete a single blog entry?
So, we're looking at three tables at minimum:
"blog_owners":
OwnerID | OwnerName | OwnerEmail 1 Sammy P. sa***@me.net 2 Jenny S. je***@example.com 4 Marvin H. ma****@home.net
"blog_table":
BlogID | BlogOwner | BlogTitle 1 2 "Jenny's Cool BlogWorld" 2 4 "Marvin's Blog o Plenty"
"blog_entries":
EntryID | BlogID | BlogEntry 1 2 "My name is Marvin. I am 11 years old." 2 1 "If my name wasn't Jenny, things would be easy" 3 1 "Today mom said, 'Jenny you are great!'"
Therefore, the table seeing the most action/size increase would be "blog_entries".
Oh well, your 'blog_entries' is my 'blog_table', but your mail confirms
that what I'm doing is right. What is the most advisable engine for this table - Innodb or MyISAM?
i can't see why you'd even consider InnoDB for this project. what makes you think you need transactions for this project?
Also, I do need FULLTEXT search, and since Innodb doesn't support FULLTEXT indexes, are there 3rd party tools that could do the indexing
well you've answered your own question here, dont you think. forget third-party tools. again, there is no reason from what you've given as to why InnoDB should even be considered.
Well I was also considering factors like
increased speed due to row level locking in Innodb
and other factors (unknown to me) where my choice of Innodb would be
justified even though I am not using transactions..
"siliconmike" <si*********@yahoo.com> wrote in
news:11*********************@g49g2000cwa.googlegro ups.com: Well I was also considering factors like increased speed due to row level locking in Innodb and other factors (unknown to me) where my choice of Innodb would be justified even though I am not using transactions..
you won't notice it - go MyISAM all the way for this project. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: jackson marshmallow |
last post by:
I have just recreated several (large) tables in the database as InnoDB and
reloaded them using my client application... These tables used to be MyISAM.
I haven't tried playing with any InnoDB...
|
by: Marek Kotowski |
last post by:
I am new to MySQL and this is
a simple question: what table type
to choose: MyISAM or INNODB?
I need a referential integrity to be
checked, so – I know – INNODB
is the only choice, at least...
|
by: Stefan van Roosmalen |
last post by:
I want to use constraints, so I will have to use innodb tables (according to
the website mysql.com).
But, what is the difference between myisam and innodb tables ??
And why is there a comment...
|
by: Mike Ho |
last post by:
I'm wondering if there is a way to retrieve Foreign Key declaration
information on both MyISAM and InnoDB tables.
Of course, I understand that MyISAM doesn't support Foreign Keys,
however, it...
|
by: Reuben Pearse |
last post by:
Hi all,
I've just converted the tables in a big database (approx 27 million
records) from MyISAM to InnoDB. When I was using MyISAM I backed up
the database by stopping MySQL and then copying...
|
by: Good Man |
last post by:
Hi there
I have a database with about 20 or so tables, maybe a few thousand rows
in each. I am starting to do more complex things with my insertions etc,
and I want to start to use...
|
by: crescent_au |
last post by:
I've read articles and postings about MyISAM vs InnoDB but I am still a
bit unsure about which storage engine to use for my new project.
I am developing a website in PHP/MySQL, which includes...
|
by: fjm |
last post by:
Hi all, I'm new so please be forgiving if my question appears stupid.
Thanks to Motoma and his fine class script, I was able to put together a very nice looking template.
I am using mysql...
|
by: MysqlBeginner |
last post by:
Is this possible to have a MyISAM table on master server and change its storage engine (to InnoDB) on slave server in a replication environment?
If this is possible, what should I consider before...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
| |