Sign In | Register Now About Bytes | Help | Site Map
Connecting Tech Pros Worldwide

Which Storage engine is better? why?

Question posted by: Damodhar (Guest) on March 18th, 2008 09:35 PM
hi

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

What are functions available in MySQL?
Ivan Marsh's Avatar
Ivan Marsh
Guest
n/a Posts
March 18th, 2008
09:45 PM
#2

Re: Which Storage engine is better? why?
On Tue, 18 Mar 2008 14:30:27 -0700, Damodhar wrote:
Quote:
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.co...22-1058872.html

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


Damodhar's Avatar
Damodhar
Guest
n/a Posts
March 18th, 2008
09:55 PM
#3

Re: Which Storage engine is better? why?
Why we have need for information_schma


David Quinton's Avatar
David Quinton
Guest
n/a Posts
March 19th, 2008
08:15 AM
#4

Re: Which Storage engine is better? why?
On Tue, 18 Mar 2008 14:50:24 -0700 (PDT), Damodhar <damu.be@gmail.com>
wrote:
Quote:
>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>

lister's Avatar
lister
Guest
n/a Posts
March 19th, 2008
04:25 PM
#5

Re: Which Storage engine is better? why?
Which storage engine is better? Myisam or innodb?

There's only one way to find out.

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

Ivan Marsh's Avatar
Ivan Marsh
Guest
n/a Posts
March 19th, 2008
04:35 PM
#6

Re: Which Storage engine is better? why?
On Wed, 19 Mar 2008 09:20:17 -0700, lister wrote:
Quote:
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!"


larry@portcommodore.com's Avatar
larry@portcommodore.com
Guest
n/a Posts
March 20th, 2008
04:05 AM
#7

Re: Which Storage engine is better? why?
On Mar 18, 2:30 pm, Damodhar <damu...@gmail.comwrote:
Quote:
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.

Toby A Inkster's Avatar
Toby A Inkster
Guest
n/a Posts
March 20th, 2008
11:05 AM
#8

Re: Which Storage engine is better? why?
larry wrote:
Quote:
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/

Vertuas's Avatar
Vertuas
Guest
n/a Posts
March 20th, 2008
03:15 PM
#9

Re: Which Storage engine is better? why?
PHP highlight of the week!!!!




"lister" <listerofsmeg01@hotmail.comwrote in message
news:729a83a8-d606-42bd-9f4e-71a20344c6a7@u72g2000hsf.googlegroups.com...
Quote:
Which storage engine is better? Myisam or innodb?
>
There's only one way to find out.
>
FIIIIIIIIIIIIIIIIIIIIIIIGHT!!!!!!!!!!!!!!!!




 
Not the answer you were looking for? Post your question . . .
189,846 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).

Latest Articles: Read & Comment
  • Didn't find the answer you were looking for?
    Post Your Question
  • Top Community Contributors