Procedure cash...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bumsys@gmail.com - 07 Jul 2008 15:21 GMT

When i load to database a big file I have error: not enough procedure
cash. I change the procedure cash and try to load file again. Then the
sybase start to work slowly. Whatcan do that it works quickly?

Reply to this Message

Carl Kayser - 07 Jul 2008 16:21 GMT

> When i load to database a big file I have error: not enough procedure
> cash. I change the procedure cash and try to load file again. Then the
> sybase start to work slowly. Whatcan do that it works quickly?

Ummmm. Sybase ASE or SQL Anywhere. (I imagine the former since you mention
"procedure cache".) Which version (select @@version)? What do you mean by
"load to database a big file"? (load database <dbname> from ...?) Or are
you inserting a file using external file system? Is this a server "out of
the box" that has not had any configurations set?

Reply to this Message

Bumsys@gmail.com - 08 Jul 2008 06:47 GMT

I insert using sql query "insert file into ...".

Reply to this Message