.NET+ MySQL On A Large Scale. Recommended?
Feb 7, 2010
I'm thinking of using ASP.NET and MySQL together on a large project. Does anyone have any experience in using these two on a large scale and are there any aspects I should be wary of? If there is a chance that there could be compatibility issues, then I may be prepared to purchase an MSSQL license, but I'd rather go the free route right now. In theory it's possible, but how easy is it to transfer a MySQL database to and MSSQL database in the future?(I'll make this a CW if requested).
View 2 Replies
Similar Messages:
Feb 20, 2010
I am working on a site where I will need to be able to track ad impressions. My environment is ASP.Net with IIS using a SQL Server DMBS and potentially Memcached so that there are not as many trips to the database. I must also think about scalability as I am hoping that this application becoming a global phenom (keeping my fingers crossed and working my ass off)! So here is the situation:
My Customers will pay X amount for Y Ad impressions These ad impressions (right now, only text ads) will then be shown on a specific page.The page is served from Memcached, lessening the trips to the DB When the ad is shown, there needs to be a "+1" tick added to the impression count for the database
So the dilemma is this: I need to be able to add that "+1" tick mark to each ad impression counter BUT I cannot run that SQL statement every time that ad is loaded. I need to somehow store that "+1" impression count in the session (or elsewhere) and then run a batch every X minutes, hours, or day.
Please keep in mind that scalability is a huge factor here.
View 2 Replies
Dec 26, 2010
i was just using mysql i installed mysql and mysql net connector. its installed successfully but unable tp add to references.
View 3 Replies
Mar 28, 2011
based on a recent article on MySpace blaming the microsoft stack not being able to easily scale here.Is this true? Is scaling an app built on the microsoft stack (asp.net mvc here) nearly impossible? does php/LAMP really scale better than microsoft?
View 1 Replies
Feb 1, 2011
I maintain a web application (ASP.NET/IIS7/SQL2K8/Win2K8) that needs to access documents, actually hundreds of thousands of documents, and growing. Currently, they are all on a Windows 2K8 Server fileshare, being accessed by UNC path (SMB). The files are in a single flat directory and I'm trying to plan how to best improve this solution. I don't want to use the SQL Filestream attribute as it would be significant effort to migrate it all into that, and would really lock in to SQL Server. I also need to find a way to replicate the data for disaster recovery, so perhaps a solution can help with that too. Options could be: Segment files into multiple directories? application would add metadata for which directory it's on (or segment by other means) Segment files into separate servers? (virtualize)Backup becomes more complicated. Application would add metadata for which server it's on
NAS Storage
SAN Storage
Put a service (WCF) in front of the files and have the app talk to the service bonus of being reusable across many applications Assuming I'm going to store on filesystem and not in database (I've read those disccusions here), which would be a more scalable solution?
View 1 Replies
Nov 8, 2010
Okay in my WebApplication i have a webform showing some pictures.The pictures - or better - the picturepath i get from a database.
With this paths i am loding the pictures into my webform.
Now i want to render a scale into these pictures. For example lets say 1px = 1cm.It should look something like in this sample picture:
Is it possible to realize somethin like that and how?!
I tryied to google something but i could not find anything!
View 6 Replies
Jan 25, 2010
I am using abcPdf to convert an HTML report into a pdf file. The pdf has to be a single landscape A4 page.Do you know if there is any way to tell abcPdf to scale the HTML page to fit on a single page in the pdf? I tried using the Magnify() method, and it scales the content but still breaks it into pages, even though it would fit on one page. I've been scratching my head on this for a while now
View 2 Replies
Mar 4, 2010
i wants to upload images on server with small scale, large scale and medium scale on server hard disk when user uploads picture on server by upload image click..
View 1 Replies
Feb 21, 2011
I have to do the following.
There is a database (SQL Server) with locations (longitude and latitude values). I need to plot the route on the map (Google or otherwise) based on those locations extracted from database. Plotting lines and map are on ASP.NET webpage.
What would be the most and cost-effective way to accomplish the task above?
View 1 Replies
Dec 22, 2010
I have a page on which I generate a load of html which is used in a html email.
Here is a bit of the code ...
Code:
[code]....
Because of the problems getting the email to look the same in various email clients, I need to convert that chunk of html to a pdf - so I can create the pdf on the fly, save it and attach it to the email.
Can anyone suggest a simple pdf generator that will just take a chunk of html and create a pdf from it? The ones I have looked at so far have what looks like a steep learning curve with hundreds of features I don't need.
View 3 Replies
Jun 7, 2010
On my X Axis, I have months. The chart shows up to 11 points, i.e. Jan - Nov of the same year, but when I add 12 points (Jan - Dec), it will do an auto label thing and change the interval for every 4 months.
How can I change the graph so that it shows 12 months before it does the auto labels?
Here is the server control code I am currently using.
[code]....
View 1 Replies
Mar 1, 2010
trying to switch to better coding practises, I am totally confused about which path to choose. For the past year I was just coding through classic asp coding methodology. Now I know about things as
3 tier custom 3 tier with Strongly typed data sets N tier applications Custom entity objects and so on
Can someone recommend me an approach for designing web applications from these? Some book or tutorial reference with simple CRUD application that would help me. I am currently stuck with strongly typed data sets as I cant find CRUD tutorials with that approach. I would like to just choose the right approach and build on it.
View 4 Replies
Jul 5, 2010
I've got an ASP.NET web project which connect to an SQL Server 2005 DataBase.I think that I'm doing the part of the database connection awfull because everytime I need to do a query (select for example) I'm creating a new connection, opening the connection, creating the command, executing the query, using the results and closing the connection.
Is the rigth way to open a connection in the start of the application and closing at the end?? How can I do that?? I'm retrieving data but what will happen to database server when the application will be used by many people?
View 2 Replies
Jul 6, 2010
I have a folder that contains lots an lots of pictures, videos, whatever and I only want people who are on my SQL08 to have access to it.Someone recommended Forms Authentication, but that seems to only open up its own aspx pages.Am I configuring it wrong or should I be using something else?
View 21 Replies
Dec 16, 2010
Why does a very simple script which inserts 26,000 records into a mysql database (myisam, no transactions) take 13 seconds in the php implementation, and then 35-50 seconds using mono+mysql connector? I thought asp.net was faster than php? Could the problem be the mono mysql connector is "platform independent", so the performance just stinks? or does asp.net suffer more overhead than php when it comes to executing each query? Aren't there any native linux binaries for mysql connector for mono that may be faster?
View 1 Replies
Jul 15, 2010
Does anyone have any applications that they recommend, whether they be downloadable or web apps, that can neatly format your .aspx code? I've had limited success trying to adjust the formatting preferences with Visual Studio itself, and spend a lot of time manually indenting/unindenting lines.
As a clarification, I'm looking for something to format the web page code, not the vb code-behind file.
View 3 Replies
Mar 10, 2011
Possible Duplicate:
MVC Learning Resources
I am assigned to a project in which ASP.NET MVC is widely used. I am new to it; can you provide me nice resources to learn it quickly?
View 7 Replies
May 20, 2010
The programmer is a C# ASp.NET Developer and is looking to learn his first scripting language. Unfortunately he never had to use it before. He is also looking for something that can be good for his career growth.
View 4 Replies
Mar 4, 2011
Has anybody used a decent jquery callendar control that you can reccomend?
View 1 Replies
Jan 11, 2010
I have used ASD.NET code using SQL Database for Transaction operation successfully. By changing the Database Code to interface with MYSQL an Error occurs. If I remove the Transaction Code from within the the application, it works OK by displaying the MYSQL data (Read Only) in the layout of the application. I am using Mysql Essential-4.1.22-win32 and MYSQL Connector ODBC-3.51.2. My objective is to EDIT the MYSQL Data.
View 8 Replies
Feb 14, 2011
I want to know how much data is recommended to make transaction in web application at a time. I have 30,000 data. I want to insert and update in different transaction. When I do 30,000 data update at one time, some times it becomes hang web application, sometimes, it becomes timeout. So I want to know what the best amount of data to do Insert or Update at a time. It may be 1000/5000.
View 21 Replies
Feb 19, 2010
it is apparent that "string builder" is better for building large string compared to sMyString = sMyString + "something";
what is a better way to search large in memory datasets? (like the example above - i know i could use loops, is there another way that i dont now about?)
View 5 Replies
Dec 21, 2010
My code is to update a record if it already exists in database else insert as a new record. My code is as follows:
protected void Button3_Click(object sender, EventArgs e)
{
OdbcConnection MyConnection = new OdbcConnection("Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=testcase;User=root;Password=root;Option=3;");
MyConnection.Open();
String MyString = "select fil_no,orderdate from temp_save where fil_no=? and orderdate=?";
OdbcCommand MyCmd = new OdbcCommand(MyString, MyConnection);
MyCmd.Parameters.AddWithValue("", HiddenField4.Value);
MyCmd.Parameters.AddWithValue("", TextBox3.Text);
using (OdbcDataReader MyReader4 = MyCmd.ExecuteReader())
{
//**
if (MyReader4.Read())
{
String MyString1 = "UPDATE temp_save SET order=? where fil_no=? AND orderdate=?";
OdbcCommand MyCmd1 = new OdbcCommand(MyString1, MyConnection);
MyCmd1.Parameters.AddWithValue("", Editor1.Content.ToString());
MyCmd1.Parameters.AddWithValue("", HiddenField1.Value);
MyCmd1.Parameters.AddWithValue("", TextBox3.Text);
MyCmd1.ExecuteNonQuery();
}
else
{
// set the SQL string
String strSQL = "INSERT INTO temp_save (fil_no,order,orderdate) " +
"VALUES (?,?,?)";
// Create the Command and set its properties
OdbcCommand objCmd = new OdbcCommand(strSQL, MyConnection);
objCmd.Parameters.AddWithValue("", HiddenField4.Value);
objCmd.Parameters.AddWithValue("", Editor1.Content.ToString());
objCmd.Parameters.AddWithValue("", TextBox3.Text);
// execute the command
objCmd.ExecuteNonQuery();
}
}
}
I am getting the error as: ERROR [42000] [MySQL][ODBC 3.51 Driver][mysqld-5.1.51-community]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order,orderdate) VALUES ('04050040272009',' &' at line 1
The datatype for fields in table temp_save are:
fil_no-->INT(15)( to store a 15 digit number)
order-->LONGTEXT(to store contents from HTMLEditor(ajax control))
orderdate-->DATE(to store date)
View 2 Replies
Oct 7, 2010
I am trying to insert html pages to MySQL with my Asp.NET project but i am getting error; You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'de Osman patlaması', '', '<div style="text-align: center"> <img src="/i' at line 1
How can i fix that problem my server side code is;
MySqlConnection myCon = new MySqlConnection();
myCon.ConnectionString = ConfigurationManager.ConnectionStrings["MySQLConnectionString"].ConnectionString;
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = CommandType.Text;
string query = @"INSERT INTO `test`.`posts` (`id`, `author`, `title`, `description`, `content`, `ispublished`, `iscommentsenabled`, `pubDate`, `lastModified`, `raters`, `rating`, `slug`, `tags`, `categories`) VALUES (NULL, '{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}', '{10}', '{11}', '{12}')";
query = String.Format(query, p.author, p.title, p.description, p.content, p.ispublished, p.iscommentsenabled, p.pubDate, p.lastModified, p.raters, p.rating, p.slug, p.tags, p.categories);
cmd.CommandText = query;
cmd.Connection = myCon;
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();..............
View 2 Replies
Nov 12, 2010
I am developing an application of library management system in asp.net. I want to implement item recomender system. when user search any bsook like c# ,the system also show related other books of c# in the botom of page.
View 1 Replies
