[1.0/1.1] Trying to find an alternative solution for a coding problem

[RohanWest]

Hi, this problem is quite common,

I would sugest that you look into asynchronous file access, this should provide an effective solution.

If you need any info about this then let me know...

Rohan

[drattansingh]

Please send me some information about a possible solution. Just as I thought, its a common problem. it has to be.


Yes penegate. The queries are being made by the server not the client. All the client does is to request to the server to query to the database.

And I don't think that anything is wrong with my setup. When for e.g. I used MySql, I could run multiple queries at the very same time, even embed a query inside of another one and it will work, but not in Oracle. With Oracle, it only allows 1 connection to the database or you will get an error saying Connection is already opened. I believe it's something with the license of oracle since the more connections you have you will have to aquire additional licenses. You cannot evem embed a query inside of another one. For e.g. if you have to execute 2 queries one after another, you have to open the connection, execute query 1, then close the connection, then re-open it again, execute query 2, then close the connection again. That's how it works.

Oh yeah, and SQL server is a novice database compared to Oracle. Only oracle could handle the huge amount of workload my application requires, so stop rolling your eyes!

[Techno]

I'm sry but that is the most crap I've heard in my life about sql server. you are very wrong. it has won awards and THE most used database system in the world. sry I don't agree

[penagate]

I'm sry but that is the most crap I've heard in my life about sql server. you are very wrong. it has won awards and THE most used database system in the world. sry I don't agree

Noted.

With Oracle, it only allows 1 connection to the database or you will get an error saying Connection is already opened. I believe it's something with the license of oracle since the more connections you have you will have to aquire additional licenses.

Are you doing the queries through the same connection? If they can't be executed simultaneously you can queue them on the server like I mentioned. It will be a little extra wait for the client but at least it should work and the wait should not be long as the overall server processing time would be roughly the same as if they were executed in parallel.

[drattansingh]

I will try you suggestion Penegate and get back to you.

Techno, Oracle is the grand daddy of sql server, sql server is microsoft for christ sake. Anyway I am not getting in an oracle / sql server argument since i use both of them. And watch your language with me. Cause You don't wanna know what a woman's scorn is like.