Hi, Why firebird/interbase? well, the server was written originally to run off a win32 interbase. It uses stored procs heavily to process requests. I believe it made sense to just port it to firebird rather than rewrite all those stored procs.
I don't know exactly what you mean by how much ram, but if I am not mistaken, there were records for each node or vertex of a map. It consisted of at least 250,000 nodes. I guess if the queries were run off an application server instead of stored procs, it would take the application longer to process the requests. I am not that familiar with the system. If I am not mistaken, firebird handles stored procs well, running them in separate threads. I believe that what made it quicker, lesser data were transfered between the db and app. If you could be more specific with what kind of queries, like does it involve updates, or just selects? what kind of selects, simple or joins, etc. What I saw them do with their db was to test if the queries, run over lan, took less than a certain time, like 200ns. If it didn't meet that standard, they went optimizing it further, like tracing which indices were used, etc. Hope that helps. Blue P.S. which was eating your CPU your DB or AppSvr? *********** REPLY SEPARATOR *********** On 7/23/2003 at 3:05 PM Winelfred G. Pasamba wrote: >actually i can easily separate the application server to a 400Mhz 128MB >K6-2 which when i tried before run nicely naman. > >the queries that run are for trial-balancing of student accounts. > >how much ram was the mapping/gis database? and why did you use >firebird/interbase db? > >thanks for your answers >-- >Philippine Linux Users' Group (PLUG) Mailing List >[EMAIL PROTECTED] (#PLUG @ irc.free.net.ph) >Official Website: http://plug.linux.org.ph >Searchable Archives: http://marc.free.net.ph >. >To leave, go to http://lists.q-linux.com/mailman/listinfo/plug >. >Are you a Linux newbie? To join the newbie list, go to >http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie -- Philippine Linux Users' Group (PLUG) Mailing List [EMAIL PROTECTED] (#PLUG @ irc.free.net.ph) Official Website: http://plug.linux.org.ph Searchable Archives: http://marc.free.net.ph . To leave, go to http://lists.q-linux.com/mailman/listinfo/plug . Are you a Linux newbie? To join the newbie list, go to http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie
