|
I think that it depends how we designed the database structure and code.
Balasubramanian K.
|
|
|
|
|
It depends who you ask - Oracle users will claim oracle, SQL Server users will claim SQL Server
To be honest, a more lot depends on the database design than the vendor.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
My appn. was working well. Suddenly It throws, the error in web config file called "It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS". I've never changed anything in my webconfig file. What the problem will be?
Tnx in adv.
|
|
|
|
|
If you have any backup folder (with a web.config) in your web application folder, you have to move that backup folder outside your application folder.
Kind regards,
simsen
|
|
|
|
|
hi,
i've added a fck editor control in a web page .i want to write text in a HTML file and shown in a FCK editor .........
how can i do it
help me out please
|
|
|
|
|
Have you asked the people that wrote the FCKEditor control?
|
|
|
|
|
That would be the logical first step.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
Wait its not free tech support here? I've been telling all our customers to email you guys directly!
|
|
|
|
|
Hi,
I am doing a project in Asp.Net using C# as code behind where there is a registration form and login form.i have to use membership & role classs in that. ihave two defined role admin and user........where admin has previlages and user doesn't have.i'm nt getting idea that how can i specify role from the registration form and with that role how can log in from login interface.i've done asp.net configaration but confused with using my own defined database and Role class.
so plz help me out with coding for that.................
|
|
|
|
|
RentACoder
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
Ive Mazumder wrote: but confused with using my own defined database and Role class.
So refactor them so that you do understand them - if you can't how can anybody else?
Ive Mazumder wrote: so plz help me out with coding for that.................
No. Its your project, you do it. Otherwise you learn nothing and I may end up clearing up your coding horrors.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Ive Mazumder wrote: plz help me out
Ummm, first use a more descriptive subject line
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
In a web page, I am displaying data (fetching from SQL Server) contains about 30 columns from 15 different tables.
For less data it works fine, but when data becomes more, performance is very bad.
Anyone suggest better idea??
Thanks in advance..
|
|
|
|
|
Create a view in place of using the tables, IT self
Yogesh Agarwal
|
|
|
|
|
Thanks Yogesh,
Even I tried by using "View" as well. I noticed, performance is much better in case of direct joins instead of view. Any other ideas?
|
|
|
|
|
If the data does not need to be 100% real time, you could have a denormalised, reporting database where you 'pump' the data to from your live database on a periodic basis. This means that all the 'joining' is effectively done when you move the data and the subsequent selects on that table are then much faster.
|
|
|
|
|
Thanks,
Seems to be a good idea. But partially the data is real time. So even for every 10 minutes, if I do data pumping, that makes wrong info in the report.
Any other way to do it in the application side??
|
|
|
|
|
As Guffa says, you need to look at your DB design - is there any way to reduce the number of joins? Can you introduce indices that will speed up your table scans? Are you limiting your data returned to the absolute minimum?
|
|
|
|
|
One table contains the Master Ids like: CategoryId, SubCategoryId, RegionId, LocationId, DepartmentId, ItemId ... etc. which is having relation with different master tables.
and there is no chance of avoiding joins.
Regarding Index - All the above mentioned fields are primary key in the respective table.
Having the "Paging" option and the "Master" tables are joined only to the page size resultset.
|
|
|
|
|
You might want to take this over to the SQL forum (probably wouldn't have been a bad place to start), and see if the big brains over there can help...
|
|
|
|
|
I appreciate your idea. I posted the same in SQL side as well and got some better ways of doing it. But I am looking out any better ways through dot net application.
|
|
|
|
|
Verify that you have indexes on the fields that you use to identify records in the query.
If you for example join in a table using:
inner join SomeTable s on s.SomeUniqueId = x.SomeExternalKey
Check that you have an index on the SomeUniqueId field. (If the field is primary key in the table, it automatically has an index.)
Run the query in Management Studio and view the execution plan. That will show you what is really done when the query runs.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
If your data is not updating frequently the use datacaching to store data, that it will not hit your database server every time. data will be read from cache itself.
You can update the cache on a particular time interval.
|
|
|
|
|
Hi, All
I just start a new program i asp.net and it confuse me in some basic concept. as you can see i just create a public class named connection then i want to initialize it on page load.
but when ever i click on any of the button, it give me the error null reference error whats wrong in ASP.NET, because same work with the windows application with C#.
plz do reply
regards
Yogesh Agarwal
public partial class Admin_Default : System.Web.UI.Page
{
Connection con;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
con = new Connection();
}
protected void Button1_Click(object sender, EventArgs e)
{
con.skysconnection();
}
protected void Button2_Click(object sender, EventArgs e)
{
con.skysconnection();
}
}
|
|
|
|
|
Hi,
Why do you make your connection int he Page_Load? I cannot see the reason for doing this. Why not in the skysconnection() method?
Kind regards
simsen
|
|
|
|