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: 297
database-design
|mysql
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