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