关于从sqlserver 2008删除大数据 [英] regarding delete large data from sqlserver 2008

问题描述

我有一个场景，我必须在多个相互依赖的表中进行更新，例如，它们之间存在关系，并且与网页中的大量数据有关，其中存在许多文本框，复选框和dropdownlis.我正在使用 jQuery.ajax 保存数据.新的数据保存方法已写入此处，并且正在运行.现在很难处理大量数据以进行更新.
我有一个想法，我将删除所有数据并将其保存为新记录.
这是个好主意吗?
在这里，我必须做些什么，以记住更新所有这些记录，而我不得不花一周的时间来编写更新方法.

I have a scenario where I have to update in multiple tables, that are dependent to each other e.g has relationship, with large data from a web page, where lot of textboxes, checkboxes and dropdownlis are there. I am using jQuery.ajax to save the data. New data save method is written there and it is working. Now it is very difficult to handle large amount of data for update purpose.
I have an idea that I will delete all data and save it as new record.
Is this a good idea or not?
what should I have to do here remembering updating all these records I have to spend a week to write an Update method.
please guide me in this seance.

推荐答案

有很多方法可以解决这个问题.
正如我建议的那样，如果您对XML有想法.
最好生成一个包含javascript中文本框，复选框等所有数据的XML，并将此xml变量传递给您的业务逻辑，以使用SQL查询操作xml.

希望你有个好主意.

There are many ways to do with this.
As I suggest you that, if you have an idea on XML.
Better to generate an XML which contains all the data of textbox, checkbox etc. in javascript & pass this xml variable to your business logic to manipulate xml with your SQL query.

Hope you get an idea.

这篇关于关于从sqlserver 2008删除大数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！