Click here to Skip to main content
13,198,482 members (66,452 online)
Rate this:
 
Please Sign up or sign in to vote.
See more:
I am trying to find out if i can get "out a memory" if i do
insert into schema.table
select * from schema2.table;

now i have about 700 000 lines in schema2.table

how big does schema2.table has to be to get out of memory?

and second question

what are the possibilities to look at so i don't get "out of memory"

Thanks,
Sas Gabriel
Posted 7-Feb-13 4:24am
Comments
ryanb31 7-Feb-13 10:55am
   
Well, first off, out of memory will happen based on how much resources your server has. So, you'll have to look into that.

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

Why would it go out of memory? Data is stored on disk and doesn't need to be in memory completely all at the same time. You just need enough disk space.

Good luck!
  Permalink  
Comments
Gabriel Sas 7-Feb-13 10:58am
   
but doing the Select statement won't use any memory?
Gabriel Sas 7-Feb-13 10:59am
   
or only very little memory? and all of the data inserted will go into disk space?
E.F. Nijboer 7-Feb-13 11:11am
   
Yes that's correct. The operation could be performed one row at a time. Even that could be broken into smaller operations by field. And field data could be handled in blocks. Operations would rather slow to a crawl before running out of memory.
Gabriel Sas 7-Feb-13 11:49am
   
good, thanks for the info

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

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy |
Web04 | 2.8.171020.1 | Last Updated 7 Feb 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100