i'm planning to design a database stucture. i'm planning to use two seperate database to keep my data for web development. Is it wise to keep data in seperate database?
I'm doing this because, each time when a user register with us in the web site, a Second Table will be auto generate/create using refrence ID from the 1st table. As we can see, there will be an big increment table for day-to-day registration for my website.
User register -->
|----Personal information (1st table)
|----All the web URL that User had. (2rd table auto create)
As we can see, we need to keep the web URL that the user have, and the URL will increase in Day By day, Maybe it could reach 100 URL.
For me, i suggest that i wanted to create a seperate databse to keep these two database. And i would like to know, is it possible to do it? Any benifit doing seperate database for my web development?