hi all ,
i have an oracle database 10g and i want user not to block the table while doing update or insert and even with select using wildcards which takes a lot of time and others will wait till they finish.

i thought of a FIFO file , that i can create under Linux , where i can put all the transactions there and i will not lock the users from work ..
this fifo file , will have IN and OUT pointers , one is used to read and the other to write .

the transactions will be executed one by one and i will not have lock or freeze system .


can i achieve that with mkfifo in Linux ? how to write in a fifo file and later read from it and put in the database?
am i using the right commands and is it true what i thought doing ?

tx for ur replies.
Regards

I'm confused; 1st you say you DON'T want a user to block the table, then you say you're going to do queries consecutively (one by one), which means the table IS blocked to other users ...
Anyway, I've used Oracle from V5-V8 and they brought in (default) row (record) level locking in the RDBMS engine as of V6.0.33 iirc.
You don't need to worry about this stuff surely?

Hi,

in fact i am facing a problem when people are doing a search for a criteria ( ex: A*) or ( BC*) and suppose i have 100 person doing that search using wildcards , i have a slow response and i have to wait for a time before i will got the results of the search.
and maybe 2 persons are doing the same search so my system will be very slow .

so i thought about FIFO to minimize the wait time .
put all these select in the FIFO file and later on create something to retrieve them and execute them.

am i thinking right ? is this feasible ?

but i dunno how to use this FIFO , to be able to write to it and read from it .

Tx for the replies
Regards