Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - views on DB Linking
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

views on DB Linking

 Post Reply Post Reply
Author
dj air View Drop Down
Senior Member
Senior Member
Avatar

Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
Post Options Post Options   Thanks (0) Thanks(0)   Quote dj air Quote  Post ReplyReply Direct Link To This Post Topic: views on DB Linking
    Posted: 04 December 2004 at 5:53pm
hiya,

can i have your views on linking databases, Access of course.. im using SQL but for clients they may be using Access.

i have my login manager and am intergrating it into the Forum,

is it best to just have them both in the same Database or linking ok.

im just wondering regarding the hosting, IE. how much more processing and ram etc.

a lot more, or do hosts not really like this.

any views at all are welcome.

you can find out more details about the intergration here with a demo link

http://forums.webwiz.net/forum_posts.asp?TID=1 2519&PN=1
Back to Top
dpyers View Drop Down
Senior Member
Senior Member


Joined: 12 May 2003
Status: Offline
Points: 3937
Post Options Post Options   Thanks (0) Thanks(0)   Quote dpyers Quote  Post ReplyReply Direct Link To This Post Posted: 05 December 2004 at 9:08am
I think it depends upon what you're thinking of as criteria for best.
 
If it's performance, both Access d's need to be loaded into memory so there's some additional overhead there. IIRC, the link index is also a separate memory load - but I might be wrong about that.
 
If it's maintainability/usability/ease of integration, keeping your app as separate as possible is probably the way to go so linking would be preferred. Also allows your app to integrate with more than just one other app/db.

Lead me not into temptation... I know the short cut, follow me.
Back to Top
dj air View Drop Down
Senior Member
Senior Member
Avatar

Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
Post Options Post Options   Thanks (0) Thanks(0)   Quote dj air Quote  Post ReplyReply Direct Link To This Post Posted: 05 December 2004 at 9:45am
cheers,

the application is seperate entirely,

the forum/login manager update each other using the User_code(s) as the identifier.

so they are really 2 different apps, the cookie checks the UserCode, and as both db are the same they have the same users and userCodes (validation).

all ive been doing is MODing the forum to use update/delete/INSERT INTO queries.

didn't want to use a seperate DB Connection so thats why i thought about linking/ in the same database.

SQL version is fine as you just need different table names, and as SQL goes its cabable of both in a DB.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.