为什么Devstax的DevCenter的行限制为1000？ [英] Why does DevCenter of Datastax has row restrictions to 1000?

问题描述

在Datastax Devcenter中为表显示1000行是有限制的。有任何理由使用此选项？

There is a limit of displaying 1000 rows for the tables in Datastax Devcenter. Any reason for having this option?

因为当查询为 SELECT count（*）FROM tablename;
无论显示1000条记录还是完整记录集，Cassandra的性能都将相同。

Because when queried as SELECT count(*) FROM tablename; the performance from Cassandra is going to be same whether displaying 1000 records or complete records set.

推荐答案

DevCenter 1.6.0版引入了结果集分页功能，使您可以浏览结果集中的所有行。

DevCenter version 1.6.0 introduces result set paging which allows you to browse all the rows in your result set.

在DevCenter 1.6.0中，有限制值设置分页大小，例如每页要查看的记录数，但仍限制为最大1000。但是，现在您可以在所有查询结果中进行向前（和向后）翻页。

In DevCenter 1.6.0 the "with limit" value sets the paging size, e.g. the number of records to view per page and is still limited to 1000 maximum. However, now you can page forward (and back) through all of the query results.

一个相关的新功能允许您将所有结果导出为CSV格式的文件或INSERT语句。右键单击结果视图区域，然后选择将所有结果导出为[CSV |插入]到文件。

A related new feature allows you to export all results to a file, either as CSV or INSERT statements. Right-click in the results view area and select "Export all results to File as [CSV|Insert]".

这篇关于为什么Devstax的DevCenter的行限制为1000？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！