Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Procedure cash...

0 views
Skip to first unread message

Bum...@gmail.com

unread,
Jul 7, 2008, 10:21:11 AM7/7/08
to
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?

Carl Kayser

unread,
Jul 7, 2008, 11:21:41 AM7/7/08
to

<Bum...@gmail.com> wrote in message
news:e0cd6173-98ff-49a2...@k30g2000hse.googlegroups.com...

> 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?


Bum...@gmail.com

unread,
Jul 8, 2008, 1:47:55 AM7/8/08
to
I insert using sql query "insert file into ...".
0 new messages