I've put 10,000 animation frames into one sprite.
My program ran just fine...
The big problem is that Construct 2 makes "thumbnails" when dealing with Animation Frames and it refreshes those thumbnails quite often while working with your Animation Frames and at 10,000 frames that process was VERY slow.
My .PNG images were 300x70 pixels.