Databases ::asp.net 2010 And Mysql Are Practical For 10 Million Records ?
Aug 12, 2010
I am developing a large e-commerce system.
I am using asp.net 2010 with mysql database. Is it practical for large amounts of data ? say 10 million records ? cuz some people said to me that using this combination, i'll be having performance issues as database grows.
I have Revision column in Quote table with time stamp (MySql table) now i am viewing the entire date and time my end user want to view only Date he doesnot want to see time how can i pull only date.i am displaying revision column in two ways one in grid view and another one in field value
Query in my Grid view
Dim query As String = "SELECT QuoteNumber,Revision,Vendor,PartNumber,status,Customer,Requestor from quotes"
On select check box in grid view, filed values will be loaded with data.
I'm trying to delete a bunch of records in mysql. The record info to delete (userid, name) is stored in an arraylist. It seems to only delete the first record and gives an error ("Transaction has already been rolled back or is not pending.") afterwards. I have the transaction commit inside the loop which I think is the issue but not sure how to go further if I bring it outside of the loop. Here's the relevant bits of the code.
try { ArrayList alist = new ArrayList(); //alist gets populated with data like (12345,robot)(23456,car) here. MySqlConnection conn2 = new MySqlConnection(query_connection); conn2.Open(); MySqlCommand command2 = conn2.CreateCommand(); MySqlTransaction mytransaction; mytransaction = conn2.BeginTransaction(); command2.Transaction = mytransaction; for (int i = 0; i < alist.Count; i++) { string[] s = alist[i].ToString().Split(','); try { command2.CommandText = "DELETE from users_settings WHERE UserID=" + s[0].ToString(); command2.ExecuteNonQuery(); command2.CommandText = "DELETE from users WHERE ID=" + s[0].ToString(); command2.ExecuteNonQuery(); mytransaction.Commit(); } catch (Exception e){ mytransaction.Rollback(); } } } catch(Exception e){ }
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?
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.
I just moved to a new 2008 64 Bit Server. We are using MySQL, now also the 64 Bit version. Now I found out that there is a 64 Bit ODCB Driver, but not an 64 Bit Net/Connector.
Is that an issue or is the .NET Connector by default 32 and 64 Bit?
I want to use MVC 2 with MySQL database. Is it possible?because my shared hosting limits the size of SQL Server database, but there is no limit on Size of MySQL database.MySQL seems to take less disk space than SQL Server database which is costly on the Internet.
i have populated the gridview dynamically and set the ShowDeleteButton = true.. i have the delete command but i cant delete the specific row i wanted to delete..
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { string ann = (GridView1.DataKeys[e.RowIndex].Values[3].ToString()); MySqlCommand update = new MySqlCommand("DELETE FROM announcement where ID = '"+ann+"'", conn);
[Code]....
how to get the values of the row that i want to delete.
I did all the instructions which are in the following link: [URL] in order to do a connection between MySQL database and ASP.NET but I did not successed. Sometimes, it told me that I have a mistake in the <asp: button> and sometimes it told me that I did a mistake in calling (addImage) method. And this is my whole code:-
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="HW5._Default" %> <script> public class DataAccess { private string _strConn = @"Driver= {MySQLODBC 3.51 Driver};SERVER=localhost;DATABASE=test1;"; private OdbcConnection _objConn; public DataAccess() { this._objConn = new OdbcConnection(this._strConn); } // This function adds the Images to database public string addImage(timestamp id, byte [] data,string extension) { string strSql = "SELECT * FROM File"; DataSet ds = new DataSet("Image"); OdbcDataAdapter tempAP = new OdbcDataAdapter(strSql,this._objConn); OdbcCommandBuilder objCommand = new OdbcCommandBuilder(tempAP); tempAP.Fill(ds,"Table"); try { this._objConn.Open(); DataRow objNewRow = ds.Tables["Table"].NewRow(); objNewRow["Extension"] = extension; objNewRow["Data"] = buffer; objNewRow["ID"] = id; ds.Tables["Table"].Rows.Add(objNewRow); // trying to update the table to add the image tempAP.Update(ds,"Table"); }.....................................
I'm trying to apply this example to my website.They use SQLServer in this link[URL]string sql = "Select * from Country Where Country_Name like @prefixText";i have to change the last part( like @prefix ) so that it wont give any errors for MySQL
I am trying to connect asp.net with mysql on remote pc. When i am connecting asp.net with localhost mysql it is working properly but when i change "localhost" with IP address it show error.
I have the following piece of code in my web.config file.. I am trying to connect to a MySQL database. The code compiles fine and when I am ruuning the website I come across this error - 'Keyword not supported: 'server'.':
I´m involved in a project that requires MySQL interaction, and I´m designing (or programming) the front end interface. SCENARIO: I´ve a MySQL database. (Now... Imagine a Webpage.aspx). I have a table inside the page with 2 rows: The first row has 3 columns... yes, cells!!, and the another one has no columns. In the first cell (1 row, 1 column) I have a treeview with a panoramic of my database (Treeview-Datasource: XML file that I build by myself with the hierarchy of my database). Then, in the 2nd cell (1 row, 2 column) I have a Radiobuttonlist; the aim of this cell is show only the name of every data placed in the selected entity (located in the treeview). And in the third cell (1 row, 3 column) I have 3 buttons: the first one is "NEW" (Should create a new item in the entity of the database - selected in the treeview) the second one is "EDIT" (Should edit the item of my database_entity selected in the radiobuttonlist) And the third one is "SAVE"... (No words!!)
In the fourth cell (2 row, unique column)I have a FormView. To fill data, to arrange it in two columns, and to show textboxes allowing me introduce information to perform the button actions. I´m new in this, but I´ve seen that probably, I can make it using views (programming them in the database) or using XML files (declarating and querying my database as well as I want) but, in any case, the two ways requires build a view or xml file for every entity of my database that I want modify. I´m Sure that all of us know a short method or something.