Exception of type System.OutOfMemoryException was thrown?.

Question

1.00/5 (2 votes)

See more:

autually i am sending the data from datatable to table valued function. i am sending the id values around 1 to 10000 rows. i am passing the id values to table valued function inside select query. but it showing out of memory exception. and some time it showing pageload connection is reset like it is showing in asp.net with c#. please anybody help me.

Posted 25-Nov-15 5:40am

Member 12154439

Add a Solution

Comments

CHill60 25-Nov-15 11:46am

We'd need to see some code in order to help you

Member 12154439 25-Nov-15 11:58am

sp : select id from tbl_prod where id in ( table valued paramerter)
coding i store the datatable to pass the sp .

ZurdoDev 25-Nov-15 12:37pm

You have to simplify it. You're running out of memory. What can we do?

Aravindba 26-Nov-15 4:54am

Try to pass 1 to 1000 values and check it work or not ,Actually "table valued paramerter" got 10000 values,so u pass one id to "table valued paramerter" for checking condition,so ur sql use more system memory.Check in internet how to increase sql memory or try to pass only 1000 records.

Philippe Mori 26-Nov-15 12:15pm

Avoid showing more than 1000 rows. Big table are hard to use.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sinisa Hajnal · Answer 1 · 2015-11-25T21:58:00

Solution 1

Try

SQL

select id from tbl_prod tp inner join table_valued_parameter tvp on tp.id = tvp.id

Posted 25-Nov-15 21:58pm

Sinisa Hajnal