Abaksoft Posted March 20, 2015 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
Abaksoft Posted March 20, 2015 Author Posted March 20, 2015 Anyone ? Otherwise, what DB Server are you using with Unigui ? It can give good statistics. Thx... Quote
Administrators Farshad Mohajeri Posted March 20, 2015 Administrators Posted March 20, 2015 Using MyDAC + MySQL on our customer portal. Quote
rencarnacion Posted March 21, 2015 Posted March 21, 2015 I'm Using FireDac with SQL server very powerfull Quote
adragan Posted March 21, 2015 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
Abaksoft Posted March 21, 2015 Author 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
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.