database design suggesion

Posted by Bharanikumar on Stack Overflow See other posts from Stack Overflow or by Bharanikumar
Published on 2010-05-03T10:47:23Z Indexed on 2010/05/03 11:18 UTC
Read the original article Hit count: 280

Filed under:
|

Hi , am going to start new travel site, I want some advise from guru's regarding database design , Things coming to picture are, Book taxi online , This is the core idea, So i like to implement lot of jquery,ajax stuff in my site ,

Main thing site must run veryt fast,safe,security, In mysql , which typw shall i use, MYISAM OR INNODB

Which is best type for ajax works, fast,safe ,secure ,performance view .

This is my demo site, Just look this site, i implemented some ajax stuff here, my-url

In this site please choose the postcode in the taxifrom tab,

It ask you value please enter, just enter nw7 , See How long it will take for response,some time no response and system goes to hang or idle mode,

Also please look the diversion , select No diversion, There you will list of textbox, enter the nw3 then hit the search icon , See after 80seconds only , you will get response from DB, See this too bad response ...

This is DB , my Database type if myisam ,no idexing , no fulltext and nothing...no constraints, So please advise me , which database type i choose,

Myisam or innodb,

Thanks Bharanikumar

© Stack Overflow or respective owner

Related posts about database-design

Related posts about mysql