paging ms sql server 2008 [英] paging ms sql server 2008

问题描述

您好，

我有一个带有一个blob字段的sql server 2008数据库，我在VB .net 2008中使用ado .net（sqldataadapter，sqlconnection，dataset）创建了一个从扫描仪插入的表单我希望与其他数据一起存储的文档图像。我的问题是我已经达到了大约160条记录，并且由于blob字段而看到应用程序消耗了计算机内存。我有更多的记录要插入。我想询问是否有任何教程或链接，甚至更好的sql字符串将进行分页（类似于Mysql中的限制），这意味着一次只加载15条记录，当我进一步导航以卸载前15条并加载下一条时，任何帮助。



谢谢

解决方案

首先我建议将图像存储在一个单独的表中 - 这将有助于使用其他数据进行分页。

还建议在图像字段上使用FILESTREAM属性



您可以找到以下内容文章有用



http://www.simple-talk.com/sql/learn-sql-server/an-introduction-to-sql-server-filestream/ [ ^ ]



和



使用Microsoft .NET从SQL Server中检索和检索图像 [ ^ ]

Hello,
I have an sql server 2008 database with one blob field, I created in VB .net 2008 with ado .net (sqldataadapter, sqlconnection, dataset) a form which I insert from scanner an image of a document which I want to store among with other data. My problem is that I have reached about 160 records and see that computer memory is consumed by the application because of the blob field. I have many more records to insert. I want to ask if any tutorial or link or even better the sql string that will do paging (something like limit in Mysql), meaning to load only 15 records a time and when I navigate further to unload the previous 15 and load the next, any help.

Thank you

解决方案

Firstly I would advise storing the images in a separate table - this will help the paging with the other data.
Using the FILESTREAM attribute on your image field is also advised

You may find the following articles useful

http://www.simple-talk.com/sql/learn-sql-server/an-introduction-to-sql-server-filestream/[^]

and

Storing and Retrieving Images from SQL Server using Microsoft .NET[^]

这篇关于paging ms sql server 2008的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！