SQL query

[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

[1D4LV]

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]

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]

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]

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.