CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • General Discussion (please no support requests here!) (Moderator: Michał Mach) »
  • Is there a non-web based interface?
Pages: [1]

Author Topic: Is there a non-web based interface?  (Read 1725 times)

akreider

  • Guest
Is there a non-web based interface?
February 22, 2010, 09:26:37 pm
Is there an interface that works without the browser?  I could see this being useful for local access to the database and optimizing speed.

We currently have a customized mysql database which has some of its information online, and the staff uses an Access interface that we've spent huge amounts of time building.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Is there a non-web based interface?
February 22, 2010, 09:40:36 pm

there is a REST api interface. i dont think anyone has built an access interface

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

akreider

  • Guest
Re: Is there a non-web based interface?
February 23, 2010, 12:11:14 pm
I guess it would be a big job to do it and maintain it (eg. I'm not volunteering!), as you are regularly churning out new releases.

I think my organization should be adopting civicrm, but at least one (very key) person is going to reject it based on having to wait the 200ms-1 second for page loads (our Access application is probably more like 50ms).  Hopefully speed won't be an issue in several years.

I regularly use the MySQL GUI - and that is awesome for speed.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Is there a non-web based interface?
February 23, 2010, 12:18:38 pm
it depends on the speed of the server, what u cache etc. We've been working on improving core contact view performance in 3.1.3 (coming out this week). lots more optimizaton changes in future 3.1.x releases (primarily due to a fairly big client project).

 There are lots of other techniques to also improve performance.

1. get a faster server :)
2. separate the db server and web server
3. Use a PHP Optimizer (Zend Platform or APC etc)
4. Use memcached to avoid hitting the DB
5. aggregate js/css using drupal's performance settings (added in 3.1.3)
6. check for mysql slow queries and report on forums preferably with a patch to fix it
7. ensure you have mod_expires and mod_deflate installed and working on your apache config
8. If on Drupal, use css / js aggregration to ensure that all the small js/css files are bundled as one large file
9. Ensure that mysql server has query caching turned on. Tune mysql settings for your DB size and give it enough RAM

i suspect doing some/all of the above will increase performance big time :)

lobo
« Last Edit: February 25, 2010, 10:42:36 am by Donald Lobo »
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • General Discussion (please no support requests here!) (Moderator: Michał Mach) »
  • Is there a non-web based interface?

This forum was archived on 2017-11-26.