I’ve developed a few applications now using Microsoft Access and PostgreSQL. Simple reason – developing front-end using Access gives results very quickly, while PostgreSQL provides scalability and reliability needed at the back-end.
However, I’ve started to see several performance problems. Basically, certain complex query finished very quickly, while other (seemingly) simple ones takes forever.
Am still not able to pinpoint where the exact location of the culprit – Access, PostgreSQL, or a bit of both. So far I’m still doing research to resolve this.
Anyway, here’s what I’ve found so far:
Microsoft Access Performance Tips
- Blue Claw’s Performance Tips
- Granite Consulting’s comprehensive guide, lots of pointers
- How Granite Consulting gained 85x performance increase
- Several tips from ATTAC Consulting Group
- Better Performance with BeginTrans and COmmitTrans
- Make loops goes faster – combined with above, could give you serious boost
- How to speed up Microsoft Access when using ODBC
PostgreSQL Tuning Tips
- Basic PostgreSQL tune up – good for starters
- PostgreSQL tuning tips from Lyris – the famous list manager software
- PostgreSQL 8 Performance Checklist – gonna be a book someday, but you can start reading it now.
- Most comprehensive ostgreSQL tuning guide so far
- A good discussion on PostgreSQL tuning
Bukankah ada alternatif dari komunitas Open Source seperti OpenOffice 2.0 Base ? Apakah Bang Harry sudah pernah membandingkan antara Base dengan Ms.Access dari segi pemakaian biasa/sehari-hari dan untuk pembuatan aplikasi.
Apakah PostgreSQL lebih mantap dari MySQL sebagai back-end? Kayaknya yang lebih populer adalah MySQL.
#1 – ya, sayangnya, OO2 Base pada saat ini belum bisa memenuhi kebutuhan saya. Mudah2an segera di masa depan. Tapi pada saat ini, berbagai aplikasi saya sangat intensif di Access VBA dan DAO dengan beberapa SQL-passthru, dan yang seperti ini masih belum bisa di OO2 Base (saya lihat baru bisa untuk aplikasi database sederhana). Atau, bisa juga penilaian ini keliru karena kekurangan dokumentasi pada saat evaluasi tsb.
PostgreSQL dibuat dengan memprioritaskan reliabilitas, dan perlahan-lahan ke peningkatan kecepatan. MySQL sebaliknya, dibuat pertama kali dengan prioritas kecepatan, dan perlahan-lahan ke peningkatan reliabilitas.
Walaupun kini MySQL sudah mulai mendukung ACID, tapi terkesan tambal-sulam, dan saya membaca ada beberapa kasus masalah. Jadi, disini saya mencari selamat saja.
Thanks for the good post!
Very good post, thanks!
Blu Ray Disc Copy is a professional and practical software which supports Blu ray movies copying as well as DVD copying. You can use this Blu Ray Disc Copy software to copy Bluray disc, Bluray folder, or Blueray ISO file without any quality loss. All the contents can be copied to the target file/disc quickly and perfectly. Blu Ray Disc Copy supports all Blu ray and DVD discs and it can remove AASC, CSS, and region protection from them. So that enjoying your Blu ray discs and DVDs freely and conveniently is no longer a problem for you．．．．．
This site to each day improves more! Congratulations!
it perfomances good
Offering quality LV products with favorable prices, Louis Vuitton Outlet store is at your service. Hurry up, or you can not seize the chance.
I positively enjoying each little bit of it and I have you bookmarked to check out new stuff you weblog post
ccda practice exam /
ccdp practice test / ccent answers / ccia practice test / ccie exams / ccie security tests / ccie voice answers / ccip questions /