General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Justin-
< snip>
>>>Has anyone else seen this behaviour? Is there a limit to the number of RVs a DBC can handle?
>>Since you haven't had any other replies...I can't find any reference to a physical limitation, although I do think there's a practical one, from the point of view of performance. I tried the following example code. It worked well enough, although I stopped it after 7,932 views were added. MODI DATA isn't advisable at this point and even SET DATA TO took a few seconds
< snip>
>Well we are nowhere near that many - about 750 or so. But that does answer my question about size limitations - if you were able to add 7,932 views then we are not hitting any physical limit...
I was afraid of that. So, the behavior is something else. Can you pinpoint when it happens? Any code anywhere that does a DROP VIEW? Anybody accessing the database from another app? Any chance you have a naming algorithm that might not be working quite right? That last one is a stretch. Well, all of the questions are, I guess. :-\
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only