Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gregor_mt
Starting Member
3 Posts |
 Posted - 2008-11-15 : 16:23:36
|
| Hi folks,I have following problem: after executing statements that contains also BLOB field, records with not null BLOBs (especially with big BLOBs) are locked after SQLFetch and it leads to deadlocks when SQLExecute or SQLExecDirect is called with an update statement on such a record. Records with null or very small BLOBs are not locked and can be updated.I'll be grateful for any hint. |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-11-15 : 16:41:00
|
| I guess you are using cursors and storing your images are blobs. If thats the case, both are not adviced in MS SQL server.Store your images in a folder and the path in your db, many such examples online |
 |
|
|
gregor_mt
Starting Member
3 Posts |
Posted - 2008-11-15 : 17:02:39
|
Thank You for Your reply.Of course it would solve the problem but it isn't a solution for this error. I think fields of such types as SQL_LONGVARBINARY should fulfil their purposes.quote:
Originally posted by afrika
I guess you are using cursors and storing your images are blobs. If thats the case, both are not adviced in MS SQL server.Store your images in a folder and the path in your db, many such examples online
|
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-11-15 : 18:02:07
|
quote:
Originally posted by gregor_mt
Thank You for Your reply.Of course it would solve the problem but it isn't a solution for this error. I think fields of such types as SQL_LONGVARBINARY should fulfil their purposes.quote:
Originally posted by afrika
I guess you are using cursors and storing your images are blobs. If thats the case, both are not adviced in MS SQL server.Store your images in a folder and the path in your db, many such examples online
Its not a good idea to store images in your DB. Seehttp://www.dbazine.com/sql/sql-articles/larsen13And plenty other examples in this forum and google.Good luck |
|
|
|
|
|
|
SQL Server ODBC programming