SQL query

**badsekktor** · December 6th, 2007 02:37 PM

any developer here? may question lang ako, I have this program which is being used by around 30 clients. Ang problema eh kapag yun isang specific na user ang nag-transact, from 70 to 80 percent free na resources eh bumababa sa zero yun free tapos nag-ruruntime error na. I dont think na yun server ang problema since sya lang ang may ganun na problema lagi. wala naman ako nai-set na priorities sa database pagdating sa transactions. Any info would be highly appreciated

**1D4LV** · December 6th, 2007 02:53 PM

Originally Posted by badsekktor

any developer here? may question lang ako, I have this program which is being used by around 30 clients. Ang problema eh kapag yun isang specific na user ang nag-transact, from 70 to 80 percent free na resources eh bumababa sa zero yun free tapos nag-ruruntime error na. I dont think na yun server ang problema since sya lang ang may ganun na problema lagi. wala naman ako nai-set na priorities sa database pagdating sa transactions. Any info would be highly appreciated

looks like a database lock to me, wherein nilolock ng user yung entire database when he is using it. i am not sure ha for i am not a programmer or a database admin.

**badsekktor** · December 6th, 2007 03:25 PM

actually bro may concurrency control ang sql server 2000 so no need to worry about locking the whole database. nangyayari lang yan sa database na hindi pwede ang sharing like ms access or foxpro database.

ang mga rdbms like sql server and oracle may concurrency control in which kaya magtransact sa same database ang multiple clients without damaging the table.

yun problem is bakit inuubos lagi ang resources nung server kapag nag-transact na yun specific user na yun. I suspect a virus sa pc nila since yun ka-buddy nya eh may internet access.... try ko muna scan yun pc nila

**roninblade** · December 7th, 2007 12:04 AM

since sa isang user lang nangyayari yun error dun ka muna mag-trace ng problem. baka naman meron ginagawa yung user na hindi dapat gawin - happened to me a few times.

Applications programming is a race between software engineers, who strive to produce idiot-proof programs, and the Universe which strives to produce bigger idiots. So far the Universe is winning.

**wrcastro_ph** · December 7th, 2007 11:33 AM

Oracle DBA po ako. May locking method po ang Oracle row locking and page locking. Gumagamit din po ako ng SQL 2000, Tingin ko dyan ay may problem ang SQL statement mo. Baka pwede mong ilagay ang SQL statement mo para mas matulungan ka ng magagaling sa SQL dito. Most likely ay very large table ang ina access mo siguro.