MySQL Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community ForumsDatabasesMySQL Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here
  #1  
Old February 13th, 2003, 12:14 PM
Will Gaines Will Gaines is offline
Junior Member
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Feb 2003
Posts: 1 Will Gaines User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Question Which to use: innoDB, mySQL or a mix?

I am beginning to program an interactive web site with a database which I will have hosted remotely in a shared server. I will need transaction-safe support either by using transaction-safe tables such as innoDB or BDB, or by using myISAM with table locking in my PHP code.

From the many inquiries that I have emailed to Web hosts, it seems the vast majority offer only myISAM and other non-transaction-safe tables, and say they have no plans to offer innoDB or BDB.

Does anyone know the real reason? One host said innoDB and BDB are not good enough yet, but I do not get that impression from anywhere else on the Web; certainly not from the mySQL or innoDB home sites themselves.

Also, elsewhere I keep finding comments that innoDB and DBD are for large sites only, whether or not the site needs transaction-safe support. Yet the mySQL and innoDB manuals seems to indicate that the real difference is that they are transaction-safe, rather than that myISAM is more limited as to the size it will support well.

Do any of you know which is so, or is it both.

If you know a host that offers innoDB, please tell me their URL or email address.

TIA,
Will

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMySQL Development > Which to use: innoDB, mySQL or a mix?


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway