Search

your tables. Well, if you want good performance in SQL Queries, you need indexes. What do your tables look like? We can definitely get fast performance on a 50M row table

this part of the documentation as a module too. Could be a nice extension to the app. I like your idea @Evgeny.Shvarov !! How do you envision that, a simple index with easy access like

", "meta", "extension" ] #dim newObject as %DynamicObject = {} for index = 0:1:order.%Size() - 1 { set element = order.%Get(index) set done(element) = 1

you to write methods (that can be called as stored procedures) and use the full power of the object-oriented paradigm. Triggers, Indexes, and Views are all supported by IRIS

vis.Network(container, data, options); return network; } drawGraph(); </script> Step5: Calling above codes from app.py main file #Mian route. (index

to understand what I am doing wrong? XData Style { <style type="text/css"> #loading {width: 100%;height: 100%;top: 0px;left: 0px;position: fixed;display: block; z-index: 99

performance, the core of InterSystems technology is a highly efficient mechanism for data storage, indexing, and access. Unlike other database providers, we do not provide

parameters of this function are strings or numbers. The first one is the name of the global, then there are the indexes, and the last parameter is the value. iris_set('^time',1

) Method GetNext() As %String { #dim value As %String #dim index As %String = $order(@i%GlobalName@(""),1,value) if index'="" { kill @i%GlobalName@(index

of our universe not just because of its flexibility, but also thanks to its ability to quickly save a data thread while concurrently creating index globals for quick search. If we go

ChangeLog.DB.NameValues Extends %Persistent { /// Name Property name As %String; Index nameIndex On name [ Unique ]; /// Value Property value As %String(MAXLEN

, for that matter). That's the thing, I don't want views, I want tables, and I need indexing (which was how this all got started, the indexing is not working). I was not aware

","ODBCCONNECTION","DATA",1)=$lb("","ENS171 Samples","YJM","_system","HnBuSSuEERERntcVPGsUMQ==",0,0,"","","","",0,"",0,0,1,0,1,0,"",0) ^%SYS("sql","ODBCCONNECTION","INDEX","NameIndex

go - this will compile in USER namespace Class User.SQLForSome Extends %Persistent { Property Name As %String; Property Domains As list Of %String; Index Domains

will probably need to maintain a cross-reference (a.k.a. index) such as ^myglobalX("index1",Y)=X and check for the existence of a record here before saving a new record.