473,386 Members | 1,720 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Which Storage engine is better? why?

hi

any one can say
Which Storage engine is better? why?

What are functions available in MySQL?
Mar 18 '08 #1
8 2646
On Tue, 18 Mar 2008 14:30:27 -0700, Damodhar wrote:
hi

any one can say
Which Storage engine is better? why?

What are functions available in MySQL?
"Better" is a subjective term.

http://articles.techrepublic.com.com...2-1058872.html

--
"Remain calm, we're here to protect you!"

Mar 18 '08 #2
Why we have need for information_schma

Mar 18 '08 #3
On Tue, 18 Mar 2008 14:50:24 -0700 (PDT), Damodhar <da*****@gmail.com>
wrote:
>Why we have need for information_schma
I'm getting the feeling that we're being asked to answer someone's
exam questions...
--
Locate your Mobile phone: <http://www.bizorg.co.uk/news.html>
Great gifts: <http://www.ThisBritain.com/ASOS_popup.html>
Mar 19 '08 #4
Which storage engine is better? Myisam or innodb?

There's only one way to find out.

FIIIIIIIIIIIIIIIIIIIIIIIGHT!!!!!!!!!!!!!!!!
Mar 19 '08 #5
On Wed, 19 Mar 2008 09:20:17 -0700, lister wrote:
Which storage engine is better? Myisam or innodb?

There's only one way to find out.

FIIIIIIIIIIIIIIIIIIIIIIIGHT!!!!!!!!!!!!!!!!
Wouldn't that be like pitting a fly-weight against a heavy-weight?

--
"Remain calm, we're here to protect you!"

Mar 19 '08 #6
On Mar 18, 2:30 pm, Damodhar <damu...@gmail.comwrote:
hi

any one can say
Which Storage engine is better? why?

What are functions available in MySQL?
Well if the engine you want to store stuff in is too small like one of
those little one piston chainsaw motors then you are pretty limited by
how much stuff you can store in it. Now if you went for something
like a Hemi from a pickup truck (or better yet a semi truck engine),
you can certainly store a lot of stuff in those engines, but then you
have to figure out where to put them (they are very heavy.

Then again this is a PHP group and what a silly subject of storage
stuff in engines.

Seriously, the best "storage engine" I can think of is a piece of
paper. because when the power goes down you can still access
information from it (unless there is insufficient light, then you will
have to use another sheet of storage, to generate the light necessary
to retrieve the data from the sheet in question - mutli-purposed, what
can be better) Has no problem with text, graphics, any foreign
symbol, can even store colors. Can be indexed in a wide variety of
ways, and new uses are still being developed. Can describe complex
ideas, can be made into a variety of objects such as airplanes and
cranes. Yep. Paper.
Mar 20 '08 #7
larry wrote:
Seriously, the best "storage engine" I can think of is a piece of paper.
because when the power goes down you can still access information from
it (unless there is insufficient light, then you will have to use
another sheet of storage, to generate the light necessary to retrieve
the data from the sheet in question - mutli-purposed, what can be
better) Has no problem with text, graphics, any foreign symbol, can
even store colors. Can be indexed in a wide variety of ways, and new
uses are still being developed. Can describe complex ideas, can be made
into a variety of objects such as airplanes and cranes. Yep. Paper.
Yes, but how long does paper take to handle a complex query on a data set
of 2,000,000 records?

--
Toby A Inkster BSc (Hons) ARCS
[Geek of HTML/SQL/Perl/PHP/Python/Apache/Linux]
[OS: Linux 2.6.17.14-mm-desktop-9mdvsmp, up 2 days, 12:30.]

The Semantic Web
http://tobyinkster.co.uk/blog/2008/03/09/sw/
Mar 20 '08 #8
PHP highlight of the week!!!!


"lister" <li************@hotmail.comwrote in message
news:72**********************************@u72g2000 hsf.googlegroups.com...
Which storage engine is better? Myisam or innodb?

There's only one way to find out.

FIIIIIIIIIIIIIIIIIIIIIIIGHT!!!!!!!!!!!!!!!!

Mar 20 '08 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: Randell D. | last post by:
Folks, I once read an article in Linux Format whereby a technical writer had made performance recommendations on a LAMP environment. One of the points raised was for small columns in a database,...
6
by: Thaqalainnaqvi | last post by:
IPB WARNING mysql_query() : Unable to save result set (Line: 457 of /ips_kernel/class_db_mysql.php) There appears to be an error with the database. You can try to refresh the page by clicking...
2
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...
2
by: VK | last post by:
Does anyone have a reputable reference about internal string storage in JavaScript? (for some particular implementation I mean). Say having 1,048,576 characters long string from the geometric...
3
by: ScarletPimpernal | last post by:
Here are my Storage Engine Status. mysql> SHOW ENGINES; +------------+---------+----------------------------------------------------------------+ | Engine | Support | Comment ...
1
by: sandeepk84 | last post by:
Hi all, When i tried executing one query am getting this error. ERROR 1030 (HY000): Got error 28 from storage engine can anyone tell me how to resolve this? is this related to diskspace? ...
1
by: zek | last post by:
i get the following error from a db query Got error 28 from storage engine
1
by: abhishek26 | last post by:
I got this error #1030 - Got error 28 from storage engine when i'm trying to access in table in my database.........or when i'm trying to edit particular entry from any table this error #1030 - Got...
2
by: kdeveloper | last post by:
Hello Pythonists, I am building a non blocking socket server for incomming UDP packets. The server needs to run at least three threads: 1. getting data and pushing to "some" storage (at the...
0
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,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
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...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
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...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
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...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.