i guess you should first try to fix your SQL queries. you might have missed to complete the "where" expression.
also try to organize the queries to be CPU, memory, and time agnostic. humans can be better than the query optimizer. Eduardo Tongson said: > Robert de los Santos wrote: > >>Actually it does not consume 20GB of virtual memory, it would only >> consume >>arounf >>5 to 8GB. Im using Firebird. >> >>CPU0 states: 98.0% user, 0.0% system, 0.0% nice, 1.0% idle >>CPU1 states: 14.0% user, 5.0% system, 0.0% nice, 80.0% idle >>Mem: 1545740K av, 1513800K used, 31940K free, 0K shrd, 4772K >>buff >>Swap: 2506712K av, 1030772K used, 1475940K free 387708K >>cached >> >> >> >> > is Firebird the only thing running on that beast ? > -- > 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 > -- "There is no security in life, just opportunities." Douglas McArthur -- 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
