by

Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
    wideweide
    @wideweide
    @ujjwalguptaofficial
    Thanks for your hard work and great help
    I just want to reduce the time for query.
    I write some test code: total 100,000 datas, select from tbl where parentId=pid use 80ms(return 1000 datas);but if select from tbl where parentId=pid and deleted=0 and type=1 use 400ms(return 1000 datas too) . more conditions will cost more time ?
    sort or not ,seems not cost more time
    more columns indexing seems not cost more time too?
    I used keyPath for more cloumns,but when query not reduce time
    So What is the best practices? And suggest add some test case in idbstudio
    André Sousa
    @AVSousa_gitlab
    @ujjwalguptaofficial Hello, i need help with my select query, i want to assign the query values to my state values, when i do console log of the query values it shows fine but i cant assign them to my state due to them being considered unknow so i cant assign them the individual atributes, here is a screenshot of my code https://drive.google.com/open?id=1vUEAlpfdZPBQh-ATgF8hAHB87bkQmuch
    Thank you for your time
    Ujjwal Gupta
    @ujjwalguptaofficial

    @AVSousa_gitlab

    This is typescript typing issue, noting to do with jsstore . Just use any to make it work -

    model.models[i].VCodigo = (results[i] as any).VCodigo
    Ujjwal Gupta
    @ujjwalguptaofficial

    @wideweide there is no fixed practice - the query can take time based on amount of data & of course more filtering (where query) means more time.

    keyPath helps when you have more data on that indexes otherwise waste of resources. So keep experimenting with diff query & take whatever suits you.

    But it will take less time if first where column will have less data, so if less data it needs to filter for less data & thus faster. Hope i m making sense.

    I will document these out. thx.

    T. B.
    @number005_twitter
    Hey guys, how can I define the version in JSstore?
    Ujjwal Gupta
    @ujjwalguptaofficial
    T. B.
    @number005_twitter
    ah thanks! its just a param in the table! thanks!
    Emad Fani
    @EmadFani
    Hi
    i'm trying to make a fast connection to jsstore
    in my case i dont have the database schema
    but the database already exists
    so i need to connect to it and make a transaction
    let isExists = await connection.isDbExist('db')
    if (isExists) {
    return connection;
    }
    is it ok ?
    Ujjwal Gupta
    @ujjwalguptaofficial
    Hi - there is no concept of fast or slow connection . You have already established connection when you have created connection variable.
    Emad Fani
    @EmadFani
    @ujjwalguptaofficial thanks , i guess i didn't ask the right question but it was already solved thanks
    richard rose
    @manEatingFish_twitter
    Hi could any one help me with a query;
    from: "Entity"
    order: {by: "name", type: "asc"}
    where:
    status: { I want this to be a NOT LIKE : "Complete"}
    Ujjwal Gupta
    @ujjwalguptaofficial
    Hi @manEatingFish_twitter
    Do you mean not equal to or not like "%complete%" ?
    richard rose
    @manEatingFish_twitter
    not like "%complete%" please
    so return everything whoose status isn't complete
    there could be many stuses, complete is the only constant
    Ujjwal Gupta
    @ujjwalguptaofficial
    In that case - operators will work. Check out this : https://jsstore.net/tutorial/operators/
    richard rose
    @manEatingFish_twitter
    i tried != and it doesn't work, when I look at the query it tuned the != into a < so it only returned statuses alphabetically lower than Complete i.e Abandoned
    Ujjwal Gupta
    @ujjwalguptaofficial
    ok i see
    allow me some time, let me look into this.
    richard rose
    @manEatingFish_twitter
    Thanks. some more context
    $scope.searchQuery.where.status = {'!=': "Complete"};
    yielded
    Ujjwal Gupta
    @ujjwalguptaofficial
    In the mean time - could you add an issue on jsstore github page ? so that others people can look into it & take advantage of our conversation.
    richard rose
    @manEatingFish_twitter
    from: "Entity"
    skip: 0
    limit: 100
    order: {by: "name", type: "asc"}
    where:
    status: {<: "Complete"}
    will do
    Ujjwal Gupta
    @ujjwalguptaofficial
    I guess - you can use regex for this. https://jsstore.net/tutorial/regex/
    richard rose
    @manEatingFish_twitter
    Thanks I will try that
    richard rose
    @manEatingFish_twitter
    status: {regex: /^((?!Complete).)*$/s} worked
    Ujjwal Gupta
    @ujjwalguptaofficial
    glad to know :).
    richard rose
    @manEatingFish_twitter
    Question about limit, skip and where.
    I have this query running against 3000 entries
    from: "Entity"
    skip: 0
    limit: 100
    order:
    by: "name"
    type: "asc"
    on scroll i load the next 100 entries by altering the skip
    this all works correctly and they are sorted alphabetically, however when I add a where clause;
    from: "Entity"
    skip: 0
    limit: 100
    order: {by: "name", type: "asc", idbSorting: true}
    where:
    searchterm: {like: "%and%"}
    each group of 100 results is only sorted within its self
    it appears that the 100 limit based on the skip is take from an unordered result from the where, and then subsequently ordered within its self
    richard rose
    @manEatingFish_twitter
    Is this correct behaviour fro IndexedDB? if so is there anything I can do to make the the where and order occur before the skip and limit is applied?
    Let me know if you can regenerate.
    akhilponnala
    @akhilponnala
    Hi guys,
    How can we use union.
    Ujjwal Gupta
    @ujjwalguptaofficial

    Hi @akhilponnala

    right now, jsstore doesn't support union. Please add an issue on jsstore github page.

    Thanks.

    akhilponnala
    @akhilponnala
    Hi @ujjwalguptaofficial
    Please help me in preparing alternate query to union.
    Thanks.
    Ujjwal Gupta
    @ujjwalguptaofficial
    ok sure, looking into this.