Wrox Programmer Forums
|
ASP.NET 2.0 Basics If you are new to ASP or ASP.NET programming with version 2.0, this is the forum to begin asking questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 13th, 2007, 10:16 AM
Registered User
 
Join Date: Mar 2007
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to maheshshinde
Default distributed query processing

I m using Asp.net 2.0 as front end & sql server2005 as back end.
I want to do following program on 3 pc.Suppose there is table named student contains attributes as id,name,city & this table contains 100 rows. But this table is horizantally fragmented means 40 rows of which are on pc1,40 rows of which are on pc2 & 20 rows of which are on pc3.If i execute query e.g select * from student on any of the pc then i should get all the 100 rows of student table on which query is executed.

 
Old March 13th, 2007, 10:22 AM
Wrox Author
 
Join Date: Oct 2005
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons
Default

....This query should be executed inside the context of the Server and not as a query that goes out and looks for 3 different PC's to query the server on that machine.

Your 3 pc's should be syncing their copies of the database back to the server so that the server contains the "offical" copy of a record.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========





Similar Threads
Thread Thread Starter Forum Replies Last Post
Slow Query Processing guptamkomal ASP.NET 1.0 and 1.1 Basics 1 May 28th, 2007 08:16 AM
Article-Object Query Language for Distributed Cach sarosh Classic ASP Databases 0 May 14th, 2007 07:21 AM
query processing maheshshinde ASP.NET 2.0 Basics 0 March 21st, 2007 04:14 AM
Distributed Transaction Error ejan Pro VB 6 7 July 24th, 2006 08:01 AM
Distributed Transaction Coordinator fkumar BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 2 July 21st, 2006 12:26 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.