Forum
Pengirim: roma
irwan says...
20 March 2009
Awalnya sih standar pake php dan mysql doang, dengan member sedikit
(kurang lebih 1000) masih enteng, bw kecil, dan load server kecil. Tapi
sekarang dengan member sekitar 8000an, udah kerasa berat, lelet dan
server load makin tinggi.
Akhirnya gwe pindah ke XML yang
katanya bisa mengatasi masalah gwe (maklum hostingnya virtual dengan
spec yang minim). Setelah xml di terapkan, optimasi bisa hingga 50%,
yang tadinya server load gede jadi berkurang, mysql query load jadi
kecil karena query jadi lebih sedikit, tapi dampaknya space jadi nambah
soalnya tiap member ada beberapa file xml, jadi ada sekitar 14.000
lebih file xml yang masing2 rata-rata 10kb perfile.
Intinya, xml
bisa menggantikan fungsi mysql dalam penyimpanan data (walau tidak
semua) dan dilain sisi, xml bisa lebih mengoptimasikan kinerja web.
Contoh
penerapannya sih gak gitu susah, di web gwe ada yang namanya service
ShoutBox, shoutbox ini dipasang di web masing-masing member semacam
guestbook lah, nah sebelum menggunakan xml, setiap menampilkan shoutbox
berarti ada 2 query, 1. Query User (member pemilik shoutbox), 2. Query
list Shoutbox (messege). Jika satu website dikunjungi 2 orang dalam
waktu bersamaan berarti ada 4 query, itu hanya satu member, dikalikan
jumlah member doneeh.com. Akibatnya mysql query load jadi full dan
server load juga full.
Lalu solusinya, yang tadinya harus
mengquery database setiap ingin menampilkan Shoutbox digantikan dengan
fungsi parsing xml, jadi sudah tidak menggunakan query ke database tapi
hanya membaca file xml. Ini lebih ringan dan optimal.
Penerapan
seperti ini bisa juga di lakukan di situs-situs seperti portal yang
biasanya menampilkan berita-berita, jika berita-berita tersebut diambil
dari xml, jelas akan lebih mengurangi load.
Ini cuma sebutir kegunaan, keunggulan dan penerapan xml, masih banyak lagi yang bisa kita lakukan dengan xml.
website:
max says...
20 March 2009
Extensible Markup Language (XML) is a simple,
very flexible text format derived from SGML (ISO 8879). Originally
designed to meet the challenges of large-scale electronic publishing,
XML is also playing an increasingly important role in the exchange of a
wide variety of data on the Web and elsewhere.
This page
describes the work being done at W3C within the XML Activity, and how
it is structured. Work at W3C takes place in Working Groups. The
Working Groups within the XML Activity are listed below, together with
links to their individual web pages.
You can find and download
formal technical specifications here, because we publish them. This is
not a place to find tutorials, products, courses, books or other
XML-related information. There are some links below that may help you
find such resources.
You will find links to W3C Recommendations,
Proposed Recommendations, Working Drafts, conformance test suites and
other documents on the pages for each Working Group. Each document also
contains email addresses you can use to send comments or questions, for
example if you have been writing software to implement them and have
found problems or errors.
Please do not send us email asking us
to help you learn a language or specification; there are plenty of
resources online, and the people editing and developing the
specifications are very busy. We are interested in technical comments
and errata.
If your organization would like to join the W3C, or
if you would like to participate formally in a working group (and have
the necessary resources to attend meetings)
website:
Tambah Komentar