Abaksoft Posted March 20, 2015 Share Posted March 20, 2015 Hi, I would like your expertise : 1. Best performance with unigui 2. Connectivity (ibDac, myDac, dbExpres...) 3. Stress Increase in load (multi cession) Thx Quote Link to comment Share on other sites More sharing options...
Abaksoft Posted March 20, 2015 Author Share Posted March 20, 2015 Anyone ? Otherwise, what DB Server are you using with Unigui ? It can give good statistics. Thx... Quote Link to comment Share on other sites More sharing options...
Marlon Nardi Posted March 20, 2015 Share Posted March 20, 2015 FireDac + Mysql the best Quote Link to comment Share on other sites More sharing options...
Administrators Farshad Mohajeri Posted March 20, 2015 Administrators Share Posted March 20, 2015 Using MyDAC + MySQL on our customer portal. Quote Link to comment Share on other sites More sharing options...
rencarnacion Posted March 21, 2015 Share Posted March 21, 2015 I'm Using FireDac with SQL server very powerfull Quote Link to comment Share on other sites More sharing options...
adragan Posted March 21, 2015 Share Posted March 21, 2015 UniDac + Firebird -> Easy to install anywhere. No maintenance for DB. Server very easy to program (sp, triggers, views, selectable stored proc. etc ) On table in excess of 10 mil, response time in index search under 2 sec. ( from the time user presses "Search" to when screen is updated) UniDac + Postgres -> Server more pretentious but has lots of usefull features. mySQL -> Not used lately because we don't know how Oracle's policy will evolve. Not checked lately but it used to have problems with concurent updates. So if it's an application that mostly reads , it's ok. If it is an ERP, WMS I would be more carefull. IBX -> Use in the past. Not reccomended ! Zeos -> Free. Has some drawbacks but is usable for budget projects. Quite fast ! FireDac -> Just started to check on them. Firebird vs Postgres Selects/updates almost the same speed. Inserts Firebird lags behind but keeps the index structure up to date which is not the case for Postgres. pgsql ->. Lots of features but does not verify properly variables . You can find yourself in the situation when after 6 months a loop discovers that a variable does not exist ! It reminds me of the Basic times ! Firebird -> Very strong programming language. Checks everything ! Not so good to signal errors ! Stupid messages ! N.B. In Firebird you have to be very careful how you handle transactions. It drives mad the mySQL programmers ! I have the "feeling" that Apache has better response time. Maybe it's just my feeling. 3 Quote Link to comment Share on other sites More sharing options...
Abaksoft Posted March 21, 2015 Author Share Posted March 21, 2015 Oh... Very interesting ! It's good to hear. Thx to all, a special mention to adragan with your recital topic. Quote Link to comment Share on other sites More sharing options...
asapltda Posted April 6, 2015 Share Posted April 6, 2015 firebird + sqldirect good perfomance Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.