24.06.2012, 12:30
You have two options that i can think of.
1): See if you can increase the array size to fit the query (without the stack/heap collision warning)
2): Do several queries.
I'd favor increasing the array size. It wont be too bad on memory because it's a local variable and will be destroyed when it goes out of scope, and it will be faster than several queries.
If you get the stack/heap warning you should do several queries.
EDIT: Also might be better if you sort all that data into separate tables.
1): See if you can increase the array size to fit the query (without the stack/heap collision warning)
2): Do several queries.
I'd favor increasing the array size. It wont be too bad on memory because it's a local variable and will be destroyed when it goes out of scope, and it will be faster than several queries.
If you get the stack/heap warning you should do several queries.
EDIT: Also might be better if you sort all that data into separate tables.